Forms: IF statement on Calculated text field for numeric 'range' | Community
Skip to main content
KatColbourn
KatColbourn
Level 2
July 6, 2023
Question

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

  • July 6, 2023
  • 1 reply
  • 704 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
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
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
    Level 2
    July 6, 2023

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

    Terms & ConditionsAccessibility statement

    Loading footer...