Due this week formula

LaurieSD · 06/13/23

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?

heyjay · 07/31/24

https://community.smartsheet.com/discussion/comment/447201#Comment_447201

=IF(AND(

WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()), 
YEAR([End Date]@row) = YEAR(TODAY())), 

"This Week", "-")

Darren Mullen · 06/13/23

@LaurieSD Use the AND function to add a check for the year with the YEAR() function. Like this. YEAR([End Date]@row) = YEAR(Today())

LaurieSD · 06/15/23

Thank you Darren. Issue has been fixed

ClanMcDe · 07/31/24

I'm trying to use the same formula and get "#unparsable" error. Can you check this for me?

=IFS(WEEKNUMBER([Due Date]@row) = WEEKNUMBER(TODAY() AND YEAR([End Date]@row) = YEAR(Today()),"This Week","-"))

Andrée Starå · 07/31/24

https://community.smartsheet.com/discussion/comment/447201#Comment_447201

Hi,

I hope you're well and safe!

Try something like this.

=IF(WEEKNUMBER([Due Date]@row) = WEEKNUMBER(TODAY() AND YEAR([End Date]@row) = YEAR(Today()),"This Week","-"))

Did that work/help?

I hope that helps!

Be safe, and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

heyjay · 07/31/24

https://community.smartsheet.com/discussion/comment/447201#Comment_447201

=IF(AND(

WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()), 
YEAR([End Date]@row) = YEAR(TODAY())), 

"This Week", "-")

ClanMcDe · 07/31/24

https://community.smartsheet.com/discussion/comment/447206#Comment_447206

This worked perfectly, Thank you!

ClanMcDe · 08/01/24

@heyjay Thank you for the idea, worked well, is there a way to filter out due dates where the column in empty and no due date is listed?

heyjay · 08/01/24

Like this?

=IF(ISBLANK([End Date]@row), "Due Date is Blank", 

IF(AND(

WEEKNUMBER([End Date]@row) = WEEKNUMBER(TODAY()), 
YEAR([End Date]@row) = YEAR(TODAY())), 

"This Week", "-"))

ClanMcDe · 08/01/24

@heyjay , Yes, That's it, Thanks for lending your expertise… Been very helpful.

Due this week formula

Best Answer

Answers

Help Article Resources

Categories