IF statement returns formula statement, not value of formula
I want the value if true, value if false in my IF statement to return the results of 2 different formulas. But if returning the language of the formula itself on the value of the formula. I need this cell to show how long a position has been open, and if there is a position fill date, how long it was open before being filled. What am I doing wrong?
=IF([Position Filled Date]@row = "", "=NETDAYS([Date Position Vacated]@row, (TODAY()))", "=NETDAYS([Date Position Vacated]@row, [Position Filled Date]@row)")
Answers

Well, one reason it is returning your formula is because you have wrapped the formula in quotes. When running another formula inside of an IF statement you don't want to reuse the equal sign.
=IF([Position Filled Date]@row = "", NETDAYS([Date Position Vacated]@row, TODAY()), NETDAYS([Date Position Vacated]@row, [Position Filled Date]@row))
Does that work for you?

That did it! Thank you! I can just add an IF/AND to my statement to get rid of the #INVALID DATA TYPE when both the cells in question are blank right?

Would you ever have a Postiion filled cell populated with a Date position blank? If not, try this...
=IF(ISBLANK([Date Position Vacated]@row), "", IF([Position Filled Date]@row = "", NETDAYS([Date Position Vacated]@row, TODAY()), NETDAYS([Date Position Vacated]@row, [Position Filled Date]@row)))
This formula checks to see if the position vacated row is blank and returns a blank if it is. Then it goes through the rest of the prior formula.
Help Article Resources
Categories
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 61.3K Get Help
 321 Global Discussions
 197 Industry Talk
 418 Announcements
 4.2K Ideas & Feature Requests
 126 Brandfolder
 153 Just for fun
 124 Community Job Board
 441 Show & Tell
 26 Member Spotlight
 1 SmartStories
 278 Events
 34 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!