Sign in to join the conversation:
Hopefully an easy question...I'm just getting started using smartsheet. Can someone tell me how calendar view determines the order of items within the calendar - i.e. what is listed on top of a certain date, what's below that and so on.
Thank you!
Hi Steve,
Welcome!
I think it's sorted by the order of the rows.
Hope that helps!
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Andree is correct. It is based off of the row order. Sorting and filtering will adjust this as will collapsing parent rows.
Not to complicate the question, but... LOL
How is the order determined when the rows are from different sheets?
I'm trying to get items from one sheet in particular to show as the first item in a calendar report. Essentially, overlay the US/Canada Holiday schedule but have them always appear first.
Thanks for your input!
Andrew
On further testing I can make the sort feature work much of the time. However, it appears the longer multiday item always appears first, and then the next longest and so on and so forth. I'm surmising this is to deal with the layering of the items on the calendar.
I've used conditional formatting to provide a color indicator, but would still love to see a way to get an event to stick to the top regardless of length. Or, even more generally, a way top prioritize regardless of task length.
If anyone has any suggestions or feedback, I'd love to hear it.
Cheers!
I am completing a project to have vacation calendars submission for our office staff in seniority date order however our test has showed that even though the sorting of the sheet is in seniority order the calendar view doesn't list the staff by seniority date order but by the staff name's alphabetical order. This is making it difficult to resolve conflicts for dates in seniority order.
Smartsheet should be sorting my seniority date order for the calendar view also when the sort is determined by seniority date order. I submitted a ticket number 05349341, please assist to resolve this glitch.
How can you get rid of the uncategorized land in a report timeline view?
Please help! I understand that we can't customize the gantt chart bars anymore if it is a parent row but why am I getting random colors on the bar view in my report? I would prefer it remain grey. The first picture is the Smartsheet and the second one is the report pulling from the sheet.
Trying to understand why we don't have the option to remove a status by automation. For example, when external customer approves a proof, it fills in "APPROVED BY CUSTOMER" which then triggers automation, but the existing status of "SENT TO CUSTOMER FOR APPROVAL" remains as I cannot set automation to do that.
