Triggers over/under specific variance

Could someone help provide steps on how we would get a WORD TRIGGER to appear if the value is over 4% or under 4%?

Answers

  • KPH
    KPH ✭✭✭✭✭✭

    You can use an IF function to evaluate if the value in the column with your percentages in is over 4% and have this return different text depending on whether this is true or false. Percentages are stored in smartsheet as decimals if the column format is percent so your formula would be

    =IF([column with %]@row > 0.04, "OVER 4%", "UNDER 4%")

    If you prefer to include any that are exactly 4% as being over 4% then you can use >= instead of >