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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!