Smartsheet formula

Hi All

I have several dates populated on my smartsheet using a formula.

=WORKDAY([Bom S Date]@row, -49, {Office Hols})

I want to determine the week number from this cell =WEEKNUMBER()and I get an error #DATE EXPECTED.

Is there any way to get around this.?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!