Unable to convert to column formula

This discussion was created from comments split from: Netdays formula only on rows with a column value.

Answers

  • I am using this formula and I cannot convert it to a column-based format - what am I doing wrong

    =IFERROR(NETDAYS([REQ. DATE1]@row, [SET DATE 2]@row), "")

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    Your formula seems fine. Have you verified your column names match those in your formula exactly, and that the column you are placing the formula into is formatted as Text/Number? If those are all correct, we may need to see a screenshot of this file in order to troubleshoot. Feel free to obfuscate any confidential information or replace it with "dummy" data.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!