Question description:
This user has given permission to use the problem statement for this
blog.
Need help with the "engineering tasks summary" page based on text in a column, if the cell is "graphics" needs to be added to the engineering tasks page under the "panel & manufacture", if the cell reads "strategy / other engineering"
i hope this makes sense
Solved by S. D. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
05/10/2018 - 10:32
Hi
Excelchat Expert
05/10/2018 - 10:32
Welcome to Excel Chat
User
05/10/2018 - 10:32
ok, this is a googlesheets problem
Excelchat Expert
05/10/2018 - 10:32
That's fine
User
05/10/2018 - 10:32
https://docs.google.com/spreadsheets/d/1F1eI0MY9DNB4eEw_X274p5f3qA9Zyz-m1T5FHBQ7UQg/edit#gid=2013807367
Excelchat Expert
05/10/2018 - 10:32
I am reading through your issue
Excelchat Expert
05/10/2018 - 10:33
It will be great if you can attach your sheet here
Excelchat Expert
05/10/2018 - 10:33
Because if I access the Google Sheet online, it will give you my email ID which is against the ExcelChat policy
User
05/10/2018 - 10:34
try this.
[Uploaded an Excel file]
User
05/10/2018 - 10:34
ive exported as excel, think it should work the same?
Excelchat Expert
05/10/2018 - 10:35
Thanks. Just give me a minute
User
05/10/2018 - 10:35
:-)
Excelchat Expert
05/10/2018 - 10:35
I will download the file and check it
Excelchat Expert
05/10/2018 - 10:35
I got the file
Excelchat Expert
05/10/2018 - 10:36
Can you please elaborate on your issue ?
User
05/10/2018 - 10:37
OK, so each of the tabs with a number is a project that we have ongoing, I need to add a summary page listing out the most critical tasks and when they are due
Excelchat Expert
05/10/2018 - 10:37
I am on the "Engineering Tasks Summary Sheet"
Excelchat Expert
05/10/2018 - 10:38
Okay
Excelchat Expert
05/10/2018 - 10:39
So, Can I take the freedom to create a new summary sheet from the scratch?
User
05/10/2018 - 10:39
OK, so if you look at the subsection column i this will detail the type of task
User
05/10/2018 - 10:39
yes you can
User
05/10/2018 - 10:40
I basically want the top 10 items for panels / engineering / graphics / PM to be added to each of the section of the summary page based on the due date
Excelchat Expert
05/10/2018 - 10:40
Got it
Excelchat Expert
05/10/2018 - 10:40
Just a couple of questions
User
05/10/2018 - 10:41
fire away
Excelchat Expert
05/10/2018 - 10:41
When you say based on due date, do you mean the latest ones should be on top?
Excelchat Expert
05/10/2018 - 10:41
Secondly, I see that in the project summary that has already been created there is no column which can be used to identify the project name. Do you need such column?
User
05/10/2018 - 10:42
if that can happen then yes, I dont think that the project sheets work that way at the moment, all they have is start date and end date
User
05/10/2018 - 10:42
project name is job name, they are the same thing
Excelchat Expert
05/10/2018 - 10:42
Got it
User
05/10/2018 - 10:43
it can be re-named project name :-)
Excelchat Expert
05/10/2018 - 10:43
I will start to work on it. Please give me some time before I finish it
User
05/10/2018 - 10:43
Ok no worries
Excelchat Expert
05/10/2018 - 10:43
I will constantly keep updating you and if because of some network issues you are not able to connect to the portal you will get your file after I have completed.
User
05/10/2018 - 10:44
ok that fine
Excelchat Expert
05/10/2018 - 10:44
Also, you can extend the timer twice. It will prompt for it when it reaches around 2 minutes
User
05/10/2018 - 10:44
OK
Excelchat Expert
05/10/2018 - 10:45
Just one another question
User
05/10/2018 - 10:45
yes
Excelchat Expert
05/10/2018 - 10:45
For eg. in the Sheet Cabot Square, there are more than 10 tasks, How would you want the top 10 to be picked
Excelchat Expert
05/10/2018 - 10:46
Based on status?
Excelchat Expert
05/10/2018 - 10:46
Or Date?
User
05/10/2018 - 10:46
Status
Excelchat Expert
05/10/2018 - 10:47
So the "Not Completed" will be priority
Excelchat Expert
05/10/2018 - 10:47
Am I right?
User
05/10/2018 - 10:47
Anything "in progress" and then "not started"
Excelchat Expert
05/10/2018 - 10:47
Got it
Excelchat Expert
05/10/2018 - 10:47
Thanks :)
User
05/10/2018 - 10:47
thank you
User
05/10/2018 - 11:11
how is it going? do you need anything else from me?
Excelchat Expert
05/10/2018 - 11:20
Hey!
Excelchat Expert
05/10/2018 - 11:20
It is going fine
Excelchat Expert
05/10/2018 - 11:20
I will send file in another 10 minutes
User
05/10/2018 - 11:23
ok thank you :-0
User
05/10/2018 - 11:30
do i need to add more time?
Excelchat Expert
05/10/2018 - 11:32
Hey
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.