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)")
Help Article Resources
Check out the Formula Handbook template!