Skip to main content
Question

Formula Text Issue

  • March 1, 2021
  • 0 replies
  • 62 views

Not sure what I'm doing wrong but the formula below isn't passing the numeric value I think it would.

To set the stage:
Variable [Channel43] = Broadband Back Office
Variable [Channel46] = Video Back Office

Formula:
If(ToText([IntakeID - Channel Summary])=ToText([Channel46]), "4",
If(ToText([IntakeID - Channel Summary])=ToText([Channel43]), "3",
If(ToText([IntakeID - Channel Summary])=List(";",[Channel43],[Channel46]), "2",
If(Contains(ToText([IntakeID - Channel Summary]),ToText([Channel43] )), "1",
If(Contains(ToText([IntakeID - Channel Summary]),ToText([Channel46] )), "1", "0")))))

Record in question - IntakeID - Channel Summary = Broadband Back Office;Video Back Office

I'm interpreting that, based on the formula, it should pass "2" but it's passing "1".  I've tried using "ToText" in front of the "List" and it still passes "1".   What in the holy heck am I doing wrong with the formula?

------------------------------
Michael Sargent
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+22
  • Quickbase Alumni
  • March 1, 2021
Can you tell us an example of the contents of each of the  fields being used here and what the result is and what result you were expecting?.

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