Logical Formatting within a sheet
Just wondering if there is any possible way I can apply logical formatting within a sheet? ie I have several drop down columns and I want to be able to select one and the responses will be trigged within the other columns. If 'not yet started' is the option selected in the column titled 'stage' I want the response of 'low risk' to be automatically selected in the 'risk' column.
Answers
-
Yes, it’s possible.
You’d use one ore multiple IF function formulas.
Try something like this.
=IF(Stage@row = "not yet started", "low risk")
Did that work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
What you're describing can be set up by using a formula in the "risk" column. You can build a nested IF statement to return different values (such as "Low Risk") based on other criteria in that row.
However, the way formulas work is that you can either have a formula in a cell to automatically output information, or you can manually change the data in that cell (but you can't have both). If you manually change a value in a cell that used to have a formula, this erases the formula behind it and so it won't change then as other elements in the row update. Does that make sense?
What this means is that you would want to build into your nested IF statement every possible outcome that you'd like to see, so that it all happens automatically as the other columns update. If you would like help creating this formula, I'm sure the Community can help you with this!
We would just need to know all of the criteria & values to be output (ex, when it's "not started", output "Low Risk". When it's "In progress" but the due date is in the past, "high risk", etc). It would also be helpful to see a screen capture of your sheet (but block out any sensitive data) so that we can look at your column names & types as this will affect the formula.
If you don't want to build a formula, another alternative would be to set up Conditional Formatting rules that change the cell's colour based on criteria in that row (see here).
Let me know if you have any questions about this!
Cheers,
Genevieve
Join us at Smartsheet ENGAGE 2024 🎉
October 8 - 10, Seattle, WA | Register now
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives