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
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!