I am trying to get the formula to produce this: "MR-1001"
I have this formula so far that would save in a formula text field but would did not return a result.
If(ToText([Record Owner])="Roy, Michelle",List("MR-",ToText([Quote#]),null))
^
The is a separate field that takes the Record ID# + 1000
What am I missing?
------------------------------
cs5469 cs5469
------------------------------
Question
Type Conversion Formulas used in combination with IF and List Formulas
This topic has been closed for replies.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.