IF Function?

Alexandra Prescott

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!

Sameer Karkhanis

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, "")

Sameer Karkhanis

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, "")