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
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 84 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!