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.
I'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Hi, I'm using smartsheet to track updates on each task in a tracker. These updates may span over a year, so they get lengthy. I was excited about smartsheets because viewing these notes is a lot cleaner. However, I've just realized that there is a content limit to a cell, which is a huge issue. While excel was annoying to…
Hello, i've a question about 2 tasks. Task 1 has for example 4 hours and should be on day 1 for example 6 january. Task 2 has 30 hours and should be on start on 4 january and futher. How can i manage that on 6 january task 2 has only 4 hours? Now i got the message user is over-allocated because task 2 is planned on a full…