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

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    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

  • Sameer Karkhanis
    Sameer Karkhanis ✭✭✭✭✭✭
    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, "")

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!