Due this week formula

LaurieSD

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

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

@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

Thank you Darren. Issue has been fixed

ClanMcDe

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å

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

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

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

This worked perfectly, Thank you!

ClanMcDe

@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

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

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