Forum Discussion

MartinBolduc's avatar
MartinBolduc
Qrew Member
5 years ago

Need help on IF formula

Hi, I don't see where the error is, just need the feild to say something if another Multi-text field says something if([Task_SR/SLS Received_Check]="Completed¨,¨Candidate Search¨,[Task_Scip Subm...
Formulas and functions
MartinBolduc's avatar
MartinBolduc
Qrew Member
5 years ago
Thanks. I don<t know what is the issue, I copied yours adn Candidate Search comes up yellow and under scored red.

IF(
[Task_SR/SLS Received_Check]="Complete","Candidate Search",
[Task_Scip Submitted_Check]="Completed", "SCIP Under Review",
[Task_Site Qualification_Check]= "Completed", "In Lease Negotiations")

------------------------------
Martin Bolduc
------------------------------
MarkShnier__You's avatar
MarkShnier__You
Icon for Qrew Legend rankQrew Legend
5 years ago
please post your formula and he error message when you save
Mar

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
  • MartinBolduc's avatar
    MartinBolduc
    Qrew Member
    5 years ago
    By saving it seems to have accepted it, due to the yellow and red, thought it wouldn't ... seems ok, will give it a try..

    Thanks a lot.



    ------------------------------
    Martin Bolduc
    ------------------------------
    • MarkShnier__You's avatar
      MarkShnier__You
      Icon for Qrew Legend rankQrew Legend
      5 years ago
      Sometime the formula editor is not perfect. What counts is if it will save OK.

      Are any of the field multi-select field, or just regular multiple choice fields?

      ------------------------------
      Mark Shnier (YQC)
      Quick Base Solution Provider
      Your Quick Base Coach
      http://QuickBaseCoach.com
      mark.shnier@gmail.com
      ------------------------------
      • MeredithMoore5's avatar
        MeredithMoore5
        Qrew Assistant Captain
        5 years ago

        These are nested IF statements.

        IF([Task_SR/SLS Received_Check]="Completed","Candidate Search",
        IF([Task_Scip Submitted_Check]="Completed", "SCIP Under Review",
        IF([Task_Site Qualification_Check]= "Completed", "In Lease Negotiations")))



        ------------------------------
        QuickBase Girl
        ------------------------------