I need Help with a function
Im currently in the proccess of switching from excel to smart sheets i need a formula that will change the color of a cell based on #days before a start date of a project. essentially if a task is not completed like a dumpster isnt ordered and the project starts in 3 days the cell turns red. Im guessing the excel function will not work in smart sheets.
Thank you for your help
Answers
-
For this I'd suggest using conditional formatting instead of a formula. You can set up a rule to format the cell or row based on criteria. If you want the color to be red in next 3 and yellow in the next 10 you can set up multiple rules.
You can find an article related to how to use it here:
https://help.smartsheet.com/articles/516359-conditional-formatting?source=apphelpicon
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 462 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!