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
- 64.3K Get Help
- 423 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 59 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!