Due this week formula

LaurieSD
LaurieSD ✭✭
edited 06/14/23 in Formulas and Functions

I am using this formula =IF(WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()), "This week", "-") to pull a report if a task is due this week.


The formula is pulling tasks that were completed a year ago and pulling them into the report as due this week.

How do I correct this?


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!