I need to string together many conditions
I have 8 conditions I need to string together, if all are met the formula should return "yes" if anything any condition is false, the formula should return "". I have tried nesting If/ and statements a number of ways, but since they all need to work together I am coming up #unparsable with each iteration.
=IF(AND([Contract Signed]@row="YES",AND([Amount Owed]@row<=0,AND([Term 2 Complete?]@row="YES",AND([1st Rental Hours]@row<>"",AND([2nd Harvest Rent Hours Needed/Provided]@row="",AND([3rd Harvest Rent Hours Needed/Provided]@row="",AND([4th Harvest Rent Hours Needed/Provided]@row="",[5th Harvest Rent Hours Needed/Provided]@row<>""))))))),”YES",””)
Best Answer

Hi @JGriffin
I haven't tested your formula yet, but I noticed that you have a mixture of different types of quotation marks:
,”YES",””)
See how some of them are curved: ”
And some are straight: "
Smartsheet will need only straight ones, like so: ,"YES", "")
I'd suggest doublechecking all your quotes in the formula to make sure it's the correct type. If you type directly into a Smartsheet cell, it will create the right type of quote. Sometimes copy/pasting from another page (e.g. from a Notepad) can change the quotes to be curved, so you'll want to type them in directly.
Let me know if this resolved the issue!
Cheers,
Genevieve
Answers

You only need the first AND. It should look something like this:
=IF(AND([Contract Signed]@row="YES", [Amount Owed]@row<=0, [Term 2 Complete?]@row="YES", [1st Rental Hours]@row<>"", [2nd Harvest Rent Hours Needed/Provided]@row="", [3rd Harvest Rent Hours Needed/Provided]@row="", [4th Harvest Rent Hours Needed/Provided]@row="", [5th Harvest Rent Hours Needed/Provided]@row<>""),"YES", "")

That is how I started the formula, but I got the same #unparseable error

Hi @JGriffin
I haven't tested your formula yet, but I noticed that you have a mixture of different types of quotation marks:
,”YES",””)
See how some of them are curved: ”
And some are straight: "
Smartsheet will need only straight ones, like so: ,"YES", "")
I'd suggest doublechecking all your quotes in the formula to make sure it's the correct type. If you type directly into a Smartsheet cell, it will create the right type of quote. Sometimes copy/pasting from another page (e.g. from a Notepad) can change the quotes to be curved, so you'll want to type them in directly.
Let me know if this resolved the issue!
Cheers,
Genevieve

This looks to be working for me. All of my column types on the example sheet are text/number columns. Maybe yours aren't or maybe one or more are dropdown multiselect?
Formula:
=IF(AND([Contract Signed]@row = "YES", [Amount Owed]@row <= 0, [Term 2 Complete?]@row = "YES", [1st Rental Hours]@row <> "", [2nd Harvest Rent Hours Needed/Provided]@row = "", [3rd Harvest Rent Hours Needed/Provided]@row = "", [4th Harvest Rent Hours Needed/Provided]@row = "", [5th Harvest Rent Hours Needed/Provided]@row <> ""), "YES", "")

Thank you all! You are awesome. The issue ended up being a format problem with my quotation marks.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 10.5K Get Help
 62 Global Discussions
 46 Industry Talk
 386 Announcements
 3.5K Ideas & Feature Requests
 54 Brandfolder
 125 Just for fun
 50 Community Job Board
 466 Show & Tell
 40 Member Spotlight
 44 Power Your Process
 28 Sponsor X
 234 Events
 7.3K Forum Archives
Check out the Formula Handbook template!