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
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!