Hey All
Need some assistance if possible in numbers please. I’ve created a spreadsheet like Microsoft projects and can’t figure out how to automatically fill in the appropriate cells on the timeline based on the entered start and finish dates. Example, duration is 10 days from the start to finish I would like it to auto fill in the time line dates. Thanks in advance x
[Re-Titled by Moderator]
You can try something like this:
See the 'Days' sheet (tab) in this Numbers document (Dropbox download).
There's a lot going on in with Conditional Highlighting and such, so best study it and adapt to your needs.
I you havie trouble with the date format in the cells (this was created on a machine with the American mm/dd/yy format) then try going to File > Advanced > Language & Region and switching the document to your region.
SG
Hiya SG
Another quick question which is way above my knowledge of formatting! lol , if i create a drop down box in contractors with different items can the timeline turn different colours?
Example
item 1 turns timeline red on dates inputted
items 2 turn timeline blue on dates inputted
Thanks
AJ
Wow this is perfect!! Thank you very much your a star!!
How do I get Numbers to auto fill the appropriate cell based on the start and finished dates?
