Using WeekNumber formula with autopopulated field

Hello all,

I am using the following formula to fill Week Done from an auto populated Date Completed column. The formula will not work.

Date Complete is a Date field

Week Done is a Text field

Formula:


I am using a similar formula on a sheet where the date is manually filled in and this works perfectly.


Now if I add this formula to a row that the automated date is in the field this alternate formula does work.

BUT if I add the IFERROR then it doesn't work.


Very frustrated that a simple formula like this is not working.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!