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?
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)
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.
- 2 yrs agoLast active