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


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.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!