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...
Forum Discussion
Hey Mark!
Sure. Here is a generic copy/paste example of the semicolon-delimited result:
option from tier 3 ; option from tier 2 ; option from tier 1
Expected result:
Tier 1
The required priority is:
Tier 1 Tier 2 Tier 3
So when selections from multiple tiers are present, the formula should return the highest-priority matching tier.
A simpler example:
option from tier 2 ; option from tier 1
Expected result:
Tier 1