Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

IF and BLANK nesting formulas

I am trying to use an IF statement in the approved column that says "If status is requested, return PIPELINE, all other statuses return APPROVE, unless it's blank then leave the cell blank". Everything I try returns #UNPARSEABLE.

I had it working but someone messed with my sheet and now I can't get it back! Help :)

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions