Highlight "e" in duration column
Hi, I'm trying to highlight all tasks with an "e" in the duration column, since "e" overrides all weekends and holidays I need to be mindful as to not forget an "e" somewhere when the schedule changes.
The Conditional Formatting does not work to highlight it by just saying "if duration contains 'e' then apply this format…". For some reason it does not catch the "e" modifier not matter what i type, "e" stars around it etc.
How can i acomplish this task?
thanks//Patrik
Answers
-
Hi Patrik,
If conditional formatting is not catching "e" from duration column have you tried using the formula with =if statement? you can create new column (checkbox) and use formula: =IF(CONTAINS("e", Duration@row), 1, 0) let me know if it works.
The Real Smartsheet Enthusiast
Is there anything else we can help you with? - book your time!
MASA Consult - Your Aligned Smartsheet Partner
Find us on LinkedIn!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!