IF Function?
I'm trying to automate a workflow so that the value of the "Scorecard %" column populates the "Not started", "In process", or "Completed" columns according to the color in the "Status" column. For example, in the first row above, when yellow is selected in the "Status" column, 30% would appear in the "In Process" column.
Could I use an IF function here?
Thank you for any insight!
Best Answer
-
Observation and suggestion:
It is interesting why you would have the column names with the states of the task or the activity you are tracking. Does have a single column called "State" with values "Not Started", "In Process", and "Completed" for work instead? (You already have the color in the Status column and % in the Scorecard % columns so having these in 3 more columns seems redundant. Also, if the % is greater than 0 then doesn't it mean the task/activity has already started, so wondering why it would be red (unless it has started but past due date).
In case you want to still go ahead with your current sheet setup then you need to add simple formula for each column
IF([Status]@row = "Red", [Scorecard %]@row, "")
IF([Status]@row = "Yellow", [Scorecard %]@row, "")
IF([Status]@row = "Green", [Scorecard %]@row, "")
Answers
-
Observation and suggestion:
It is interesting why you would have the column names with the states of the task or the activity you are tracking. Does have a single column called "State" with values "Not Started", "In Process", and "Completed" for work instead? (You already have the color in the Status column and % in the Scorecard % columns so having these in 3 more columns seems redundant. Also, if the % is greater than 0 then doesn't it mean the task/activity has already started, so wondering why it would be red (unless it has started but past due date).
In case you want to still go ahead with your current sheet setup then you need to add simple formula for each column
IF([Status]@row = "Red", [Scorecard %]@row, "")
IF([Status]@row = "Yellow", [Scorecard %]@row, "")
IF([Status]@row = "Green", [Scorecard %]@row, "")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 429 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!