Formula to return a 1 if cell is between two weeks

Aaron Brown

I just started with Smartsheet 10 days ago and I just want to say this community is great! Up until now I've found the answer for every question I had on this forum.

I'm trying to get DueNext2 to return a 1 if the Due column is within two weeks from today. It isn't working and I've tried everything I know (which is very little). It seems like it should work but I keep getting Incorrect Argument errors. What am I doing wrong?

Aaron Brown

Got it!

=IFERROR(IF(AND(WEEKNUMBER(Due@row) > WEEKNUMBER(TODAY()), WEEKNUMBER(Due@row) < WEEKNUMBER(TODAY(+14))), 1, 0), 0)

That seems to be working the way I need.

Aaron Brown

Got it!

=IFERROR(IF(AND(WEEKNUMBER(Due@row) > WEEKNUMBER(TODAY()), WEEKNUMBER(Due@row) < WEEKNUMBER(TODAY(+14))), 1, 0), 0)

That seems to be working the way I need.

Genevieve P.

Hi @Aaron Brown

I'm glad you figured it out! Thanks for sharing your solution.

Cheers,

Genevieve