# Formula off multiple columns

Options
edited 12/09/19

I'm trying to build a formula that works off multiple columns to give one of the 6 state pain scale results (No pain -- extreme pain).

Here's my formula:IF(Cancel@row = 1, "No Pain", IF(Suggested@row = 1, "No Pain", IF(TODAY() - [Date Requested by School]@row > 14, "Extreme", IF(ISBLANK([Airline Contract Attached to Row]@row, "Extreme")))))

Cancel is a checkbox column, Suggested is a checkbox column, Date Requested by School is obviously a date column. Everything works fine until the Airline Contract Attached to Row column. It's throwing off the formula and giving an incorrect argument set result because it's not the right usage for what I'm trying to do.

Basically we want people attaching their airline contracts to the row, but SS isn't going to know when something is attached, so the dropdown box for the Airline Contract Attached to Row column has 2 options: Yes and N/A. If they have attached it, they choose yes and I want the face to be happy.

I've tried using IFTEXT but it doesn't read it right and makes the faces happy all the time even if they haven't attached it. Not sure why. ISBLANK doesn't work either. Not sure why. Could someone assist with something they think might work for this? Thanks!

• ✭✭✭
Options

Instead of ISBLANK, just check the value of the dropdown:

IF([Airline Contract Attached to Row]@row="Yes", "No Pain","Extreme")

• ✭✭✭✭✭✭
Options

isblank should work too, he just is missing his ending parenthesis after @row

• ✭✭✭✭✭✭
Options

Try this adjusted formula to see if it works. You were missing the ending parenthesis as L@123 said. Whenever you open a new formula within an IF statement, you have to close it before moving on with the IF statement.

IF(Cancel@row = 1, "No Pain", IF(Suggested@row = 1, "No Pain", IF(TODAY() - [Date Requested by School]@row > 14, "Extreme", IF(ISBLANK([Airline Contract Attached to Row]@row), "Extreme"))))

• Options

Thank you all! It's been hectic the last 2 days but I will check this out soon.

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!