Formula off multiple columns

Sarah Thompson

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!

Ezra

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

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

L_123

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

Mike Wilday

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

Sarah Thompson

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