Need help on IF formula

Question

Hi,I don't see where the error is, just need the feild to say something if another Multi-text field says somethingif([Task_SR/SLS Received_Check]="Completed¨,¨Candidate Search¨,[Task_Scip Submitted_Check]=¨Completed¨, SCIP Under Review, [Task_Site Qualification_Check]= ¨Completed¨, In Lease Negotiations)It doesn't work and wonder why.tks.------------------------------Martin Bolduc------------------------------

markshnier__you · Answer

Is this what you wantIF([Task_SR/SLS Received_Check]="Complete","Candidate Search",[Task_Scip Submitted_Check]="Completed", "SCIP Under Review", [Task_Site Qualification_Check]= "Completed", "In Lease Negotiations")You had missing quotes and some "dot dot" quotes which have never seen on a normal keyboard.I also suggest writing these vertically for readability and ease of catching syntax errors.------------------------------Mark Shnier (YQC)Quick Base Solution ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

martinbolduc · Answer

Thanks. I don&lt;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 · Answer

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 · Answer

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 · Answer

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 ProviderYour Quick Base Coachhttp://QuickBaseCoach.commark.shnier@gmail.com------------------------------

Forum Discussion

Need help on IF formula

Related Content

Delete Formula Button Error

Formula Assistance

Formula Url Buttons

Formula Query with custom key

Formula Date Field