Skip to main content
KatColbourn
KatColbourn
New Participant
July 6, 2023
Question

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

  • July 6, 2023
  • 1 reply
  • 708 views

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:
>46Tier 1
30-45Tier 2
19-29Tier 3
10-28Tier 4
<10Out of Scope / Reg Only

 

Thank you!!!! 🙂

Kat

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

1 reply

skyehansen
skyehansen
New Participant
July 6, 2023

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

https://experienceleaguecommunities.adobe.com/t5/workfront-questions/grouping-by-issue-age/m-p/601221#M54327

(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.

 

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

If you liked my post, please like my ideas at
https://experienceleaguecommunities.adobe.com/t5/user/viewprofilepage/user-id/17528599/contributions/ideas?filter=authored

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

    KatColbourn
    KatColbournAuthor
    New Participant
    July 6, 2023

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

    Terms & ConditionsAccessibility statement

    Loading footer...