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...
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendIs this what you want
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")
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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
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")
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 Provider
Your Quick Base Coach
http://QuickBaseCoach.com
mark.shnier@gmail.com
------------------------------
- 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__Youplease 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
------------------------------- 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
------------------------------
