Counting Parent Row for Weeks


I want to be able to Count the yellow parent weeks to say how many weeks out from current week is. For example week of 6/28 is current week. I want the proceeding weeks to say for example

7/12/20 - 3 weeks out

7/19/20 4 weeks out

The current week always gets moved to another sheet once the week is over.

Best Answer



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!