Conditional Formatting Question

Anthony D'Ambrosio

Hello Smartsheets Community:

Does anyone know if there is a way for me to set a conditional format for the following scenario (use screen shot below):

For task line 394 (highlighted in green), I want to turn this row red when the end date for this task is more than 5 weeks from the start of task line 386?

Any help or suggestions that you could provide would be greatly appreciated.

Anabisdally Castro

Hi Anthony -

I don't know how to solve that problem with pure formatting - what I would do as a workaround is create a column where I calculate the delta between the two end dates and then use that cell to apply the formatting against - if cell x is larger than 25days (assuming 5 working days a week) then apply your format to the entire row. Make sense?

Anabisdally Castro

Anthony D'Ambrosio

@Anabisdally Castro

Thank you for the response. I apologize, but I am having a hard time visualizing the formula to use. My thought was to write the formula as:

=[End Date]@row (>) [Start Date]386 + 25

In regards to the above formula the parentheses would not be around the greater than symbol. It was the only way that I could show that symbol in this comment section.

What are your thoughts and thank you so much for your help!

Best,

Anthony D'Ambrosio