Skip to main content
Question

Type Conversion Formulas used in combination with IF and List Formulas

  • September 23, 2019
  • 0 replies
  • 23 views

Forum|alt.badge.img+5
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
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24

try this

If(UserToName([Record Owner])="Roy, Michelle", "MR-" & ToText([Quote#]))



------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------