Is it possible to change colors within the same row with multiple start/end dates using Gantt Chart?

Options

I am working on a scheduling sheet and have different dates of occurrences on the same row. I would like to have the different dates highlighted in different colors. I am currently manually doing this procedure in Excel. Most of the information I have come across requires each task be on a new line and I would really like to keep everything on the same line.

Example:

Arrive Date: 1/1/22 Start Date: 1/15/22 End Date: 1/30/22 Clean Up: 2/5/22

I would like Arrive Date through Start Date to be "green", Start Date through End Date "yellow" and End Date through Clean Up Date "blue".

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!