Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a field that has a number stored in it. I want to display a text. example
when table.field = 60 display Not Started....
May be like thi:
=If(table.field = 60, 'Not Started')
You can use a MAPPING table approach to map your numbers to text:
Mapping … and not the geographical kind
Note when reading these blog posts that it doesn't matter what values you are mapping (numbers or Names or Countrys), the mapping table is just a lookup table with Key / Value pairs.