0
Formula help please.
What formula could I use to to display the value of this choice field if one is marked, or "Not Rated" text if the field is empty?
4 replies
-
Rarity = null (for the empty option - i think you might be able to use 0 to but check)
as for all other options
Rarity = 1 or Rarity = "Rare"
you are better sticking with the numbers cos thats how choice fields save the index (and then it will still work is you cahnged the text
2 for Exrtrem Rare)
etc etc
-
I think I need an if/then formula so I can get the text to display when Rarity = null?
-
This should work:
if Rarity then text(Rarity) else "Not Rated" end
-
Beauiful. That works great. Thanks Tim and Mel.
Content aside
- 3 yrs agoLast active
- 4Replies
- 319Views