Baseline/Actual Schedule formula help

Hello all,

I'm looking for some help with formulas in my schedule. With the schedule templet, I can insert the dates into the "start" and "finish" columns, the cells will auto populate. I would like to add two additional rows with "Actual Start" and "Actual Finish". When I enter dates into those rows, I'm looking for them to also auto populate the cells, but in the color red. I'd like for actual start/ actual finish rows to color over the "start"/"finish" column if there is ever an instance when they are different. I am able to do it in excel with conditional formatting, but am new to smartsheet and was wondering if it is possible to do.

Thanks in advance for all of your help.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!