Editing Formula
Aseel Hawi
✭✭✭
Hi there,
I have this formula in the Schedule Heath column (picture of sheet listed below). Currently, the default value for cells in the Schedule Health is Red. I want to change its gigantic formula so if the End date is blank, the schedule health stays blank too (instead of red). Appreciate your suggestions. Thank you!
Tags:
Best Answer
-
Try starting the formula out like so...
=IF([End Date]@row <> "", IF(Summary@row = 0, ...................................
Answers
-
Try starting the formula out like so...
=IF([End Date]@row <> "", IF(Summary@row = 0, ...................................
-
Worked!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives