Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
(Sumifs, Sumif or If ?)
Comments
-
yes, you can use the conditional formatiing
In grid view you can set the color of the row by doing something like the following
Click the conditional formatting button on the left (it looks like a table where each cell is a different color)
Then you want to add a new rule. Set condition should be that this new field you created is one of the values in the if
This format would be the background color you are looking for
and you would use entire row to change the row that color or click on it to change a specific field
If you are also using card view then you will need a separate rule for the banding of the card
-
You could also use "custom criteria" on a specific field to get in the ranges and inequalities but you would need a field to at least tell you number of days or a field with the full formula as mentioned before
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives