Aug 11 2021 02:58 AM
Hi All,
I have an excel spreadsheet which is used as a tracker as is laid out as below
ID | PLANNED START DATE |
1 | 01/01/2021 |
2 | 02/01/2021 |
3 | 02/01/2021 |
4 | 04/01/2021 |
5 | 05/01/2021 |
6 | 06/01/2021 |
To make the table for visually appealling and easier to use, is there a way to automate this in a different view to read like the below
01/01/2021 - Friday
ID 1
02/01/2021
ID 2
ID 3
'and so on'
This will make the users be able to easily see how many ID are due on each day in a simple clear format.
Many thanks,
Elliot
Aug 11 2021 03:39 AM
Aug 11 2021 03:47 AM
Aug 11 2021 07:20 AM
@Serdet If you are open for slightly alternative formats the following is easy:
Dates | Task IDs | |
Friday, January 1, 2021 | 1 | |
Monday, February 1, 2021 | 2 | 3 |
Thursday, April 1, 2021 | 4 | |
Saturday, May 1, 2021 | 5 | |
Tuesday, June 1, 2021 | 6 |
In the attached example I used =UNIQUE() for the dates but you could force the Dates so for example include March 1 and it would show blank/no task IDs
For the task IDs I used =TRANSPOSE(FILTER()) as you can see in the attached.
Aug 12 2021 12:33 AM
Hi @mtarler
Thank you for taking the time to help me with my problem.
Is there anyway to transpose other data fields in with the ID's? For example, I have another column titled 'removal or install' which I would like the data to be tagged with the ID.
Many thanks,
Elliot
Aug 12 2021 04:23 AM - edited Aug 12 2021 06:09 AM
can you give a sample sheet and how you want it to look? Like concatenate the ID and if it is "removal" or "install"? Like this:
btw, I updated the file to also fix the ranges