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

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

Sign up

Login to the community