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

ajuelsgaard

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.

Paul Newcome

You cannot use hardcoded row numbers in a column formula. change each 1 to @row.

[Column Name]@row

Paul Newcome

You cannot use hardcoded row numbers in a column formula. change each 1 to @row.

[Column Name]@row

ajuelsgaard

That worked! Thanks so much for your help and the explination!

Paul Newcome

Happy to help. 👍️