Conditional Formatting Question


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?

  • Anthony D'Ambrosio
    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!


    Anthony D'Ambrosio

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!