Forum Discussion

MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago

Re: Formula Text Issue

Perhaps there is a trailing space after the text in ([IntakeID - Channel Summary])

IF(
Trim([IntakeID - Channel Summary])=[Channel46], "4",
Trim([IntakeID - Channel Summary])=[Channel43], "3",
Trim([IntakeID - Channel Summary])=List(";",[Channel43],[Channel46]), "2",
Contains(Trim([IntakeID - Channel Summary]),[Channel43]), "1",
Contains(Trim([IntakeID - Channel Summary]),[Channel46]), "1", "0")


also when you said this

IntakeID - Channel Summary
Broadband Back Office;Video Back Office


I presume that the data is really this

Broadband Back Office;Video Back Office



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

2 Replies

Sort By
  • MICHAELSARGENT's avatar
    MICHAELSARGENT
    Qrew Cadet
    5 years ago
    Well, i have some bad news and promising news.  As for the bad news, the formula wouldn't take the TRIM function based on field type.  So then I got creative.  I knew the functions of the formula (ToText(Intake ID - Channel Summary) & List(";",[Channel43],[Channel46]).  Since obviously the two weren't equal, i wanted to see what the different was.  So, i created temporary fields with just those formulas.  And wouldn't you know, they don't match.  You can see that the totext(IntakeID - Channel Summary) appears to have a space before and after the semicolon.

    Record ID# IntakeID Temporary (IntakeID - Channel Summary)  - ToText Temporary - Broadband & Video B/O List
    4746 34,280 Broadband Back Office ; Video Back Office Broadband Back Office;Video Back Office

    So, the question I now have is whether the List function allows for specificity.  Meaning can I write it list List(";",[Channel43] , [Channel46]) so it matches the space in the ToText value?

    ------------------------------
    Michael Sargent
    ------------------------------
    • MICHAELSARGENT's avatar
      MICHAELSARGENT
      Qrew Cadet
      5 years ago
      Resolved.   Just changed the List function to include the preceding and following spaces next to the semicolon.  (e.g. List(" ; "....)  Now it works like a charm.  Thanks for helping me troubleshoot this one.

      ------------------------------
      Michael Sargent
      ------------------------------