Showing multiple dates from the same sheet row in a calendar
I have 6 columns in my Smartsheet that are date columns, two of which are start and end dates. I have got the start and end dates to appear in a calendar report, but the other ones (individual dates, not date ranges) do not show up. I cannot have them as children rows. I have tried applying conditional formatting to the columns to change the cell colour when a date is entered as I saw suggested in a similar question thread but that did not work. I cannot have an entire row/task bar highlighted, as multiple of the date columns for the same row will have data so that would overlap. Is there any formula or function that can circumvent this?
Answers
-
Hi @Elijah,
In "Project Settings" there is a section for "Date Range Display". This pair of dates is what populates the Gantt and Calendar views. There is not an option for multiple ranges being displayed for the same row.
All the best,
-Ray
-
I would also like to have multiple date ranges within the same row.
-
You can have as many date ranges as you need in any given row. As far as using dates for things like the Gantt view, you are restricted to one date pair which you define in your Project Settings.
-
@Ray Lindstrom Yes sorry I meant in Gantt view.
https://community.smartsheet.com/discussion/109985/multiple-date-ranges-within-the-same-row#latest
Help Article Resources
Categories
Check out the Formula Handbook template!