Type Conversion Formulas used in combination with IF and List Formulas

Question

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))&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;^&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; The is a separate field that takes the Record ID# + 1000What am I missing?------------------------------cs5469 cs5469------------------------------

markshnier__you · Answer

try this
If(UserToName([Record Owner])="Roy, Michelle", "MR-" &amp; ToText([Quote#]))------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commarkshnier2@gmail.com------------------------------

Forum Discussion

Type Conversion Formulas used in combination with IF and List Formulas

Related Content

Combining AND with OR in Formula Checkbox Field

Sorting Combined Text Field by Record ID#

Audi Log TIME (ISO-8601) Conversion

Formula Assistance

Conversion from textlist to text?