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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!