Counting Parent Row for Weeks
Options
Answers
-
@Paul Newcome I do that all the time. Usually it's because I get sidetracked on the main functionality of the formula rather than the problem.
My suggested formula is a little fancy, in that the formula checks from the current sunday to have the same output as the previous solutions suggested, but if you want to check from the current date to next date you could potentially simplify this further.
=ROUNDUP((Week@row - TODAY()) / 7) + " Weeks Out"
-
@L@123 Both of them are much more simple than my solution. I'm usually pretty good at not overthinking, but being as bus as I have been I was just (as you said) looking at the formula and not the overall problem.
-
That did the trick! Thank you both.
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!