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.
Column Dependencies/Conditional Formatting
Is there a way to have one column populate data based on information put in a second column? For example, I have 2 columns "% Complete" and "Task Status" I would like that if the % Complete is at o% the Task Status would auto-populate to say "Not Started". And if the % Complete is 100% the Task Status would automatically update to say "Complete". Does anyone know how to do this type of conditional formatting or dependency? Thanks!
Comments
-
I would like this function too.
Do you need to use the formula functions rather than the conditional formatting?
It would be useful to be able to create simple functions like this using conditional formatting rathr that functions.
-
This can be done with formulas! Here you go...
=IF([% Complete]1 = 0, "Not Started", IF([% Complete]1 = 1, "Complete"))
This will show Not Started if 0% (or blank) and Completed if 100%.
If you want the status to remain blank if the % complete is blank...
=IF(ISBLANK([% Complete]1), "", IF([% Complete]1 = 0, "Not Started", IF([% Complete]1 = 1, "Complete")))
Do you want the status to say anything from 1%-99% (such as In Progress)? Try this...
=IF(ISBLANK([% Complete]1), "", IF([% Complete]1 = 0, "Not Started", IF(AND([% Complete]1 > 0, [% Complete]1 < 1), "In Progress", IF([% Complete]1 = 1, "Complete"))))
Here's information on formulas in Smartsheet: http://help.smartsheet.com/customer/portal/articles/775363-using-formulas
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.3K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 143 Just for fun
- 59 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives