Workfront

katc13840706 · 7/6/23

Hello!!!

I think this is an easy one, but I'm stuck!

This field is formatted as Text, and the TOTAL POINTS for EVENT field is formatted as a number.

I have the first line working:

IF({DE:TOTAL POINTS for Event}>46,"Tier 1")

I can't seem to figure out how to add additional IF statements for other ranges. These are the ranges I'm trying to add:

Thank you!!!!

Kat

skyehansen · 7/6/23

You need to work from smallest number to largest. Use syntax that looks similar to the one in this calculation.

(i.e. if <10, X; else if <19, Y; else if <29, Z; and so on)

By the way I think there's a typo in tier 4.

--------------------------------

--------------------------------

katc13840706 · 7/6/23

Thank you, Skye! I am going to try this - appreciate the response

Forms: IF statement on Calculated text field for numeric 'range'