Forum Discussion

vikaspasula's avatar
vikaspasula
Qrew Member
5 days ago

Need help building a Formula–Text field

I’m working in Quickbase and need help building a Formula–Text field based on selections in a Multi-Select Text field. Requirement The formula should return one of three designations based on a...
formulas
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 days ago

IF(

Contains([My Semi field], "tier 1"), "Tier 1",

Contains([My Semi field], "tier 2"), "Tier 2",

Contains([My Semi field], "tier 3"), "Tier 3")