I am trying to convert a formula to a column formula and keep getting the same error. Why?


The formula I am trying to use is calculating the number of days between 2 dates: =NETDAYS([Billing Period Start]1, [Billing Period End]1)

The error message I am getting is "The column formula syntax isn’t quite right, see our help article https://help.smartsheet.com/articles/2481944 for more information."

The column type is just a text/number column.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!