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.
Answers

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?


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
Help Article Resources
Categories
Check out the Formula Handbook template!