Calculation within IF statement



I have a column formula that calculates the number of days between a ticket request and the completion date. I want the rows that do not yet have a completion date to be blank instead of "#INVALID DATA TYPE" and I tried to use to IF statement to do that - If completion date is blank, leave the cell blank, otherwise compute the variance:

=IF(ISBLANK([Completion Date]@row), "", =NETDAYS([Request Date]@row, [Completion Date]@row))

This returns "#INVALID OPERATION" on the whole column. I've tried the =IF(NOT(ISBLANK variation with the same result. Is there a way to include formulas within an IF statement? Or is there a different way to accomplish my goal here?

Thanks for you assistence!


Best Answer

  • Jacob Ernst
    Jacob Ernst ✭✭
    Answer ✓

    Hi Geoff,

    The "=" sign at the beginning, to indicate a function is being entered, is valid for the entire cell. You do not need to repeat it for each function you enter in the cell. If you change "=NETDAYS" to "NETDAYS" it shoud function as you want.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!