Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

formula for date to land on the following Tuesday

Kim_C

Kim_C ✭✭

07/20/17 edited 12/09/19 in Archived 2017 Posts

Hello,

I am calculating a date based on another date:

=[Proof to LSI]70 + 49

I would like to add to this formula so that the date will always land on the following Tuesday.

Any suggestions?

Thanks,

Kim

Tags:

0 ·

Comments

Tony Coleman ✭

07/21/17

Have a look at this thread sounded pretty similar.

Regards

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

How to sort by the summary count in my row report from Highest to Lowest?
"Please select a Target before configuring the Mapping" error in Data Shuttle
In Data Shuttle, I'm running into a "Please select a Target before configuring the Mapping" error on the Mapping page, but I've already selected a Target sheet. Mapping: Target: I ran into the error when creating a new workflow, so I went to an existing workflow to see if I'd run into any similar issues. I Next-ed through…
SUMIFS when date cell ISBLANK
I'm trying to add "if date cell is blank" criteria to my SUMIFS formula, but get "INCORRECT ARGUMENT SET" =SUMIFS({EBOM - 4" CONDUIT QTY}, {EBOM - 4" JOINT TYPE}, "GSK", (ISBLANK({EBOM - ACTUAL PROD DATE}))) What am I doing wrong?