Counting Parent Row for Weeks

ginamt3
ginamt3 ✭✭✭✭

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.

Screen Shot 2020-07-01 at 3.22.45 PM.png


Best Answer

Β«1

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!