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

Looking for the most recent submission based off date
hello I am looking to build a formula that pulls the "Mid/ EOC Rating" from a reference sheet with the criteria that the ID's match, it is the most recent submission based on Evaluation Date, and that the Evaluation was an EOC not any other options So far I have gotten to the below formula but it is still reading as…
IF level@row = X, Display short version of dashboard link, else calculation
Hello Community, I have a series of columns that are summarising the output of complex projects. I would like to be able to have a "Link to Dashboard" at the top of a column that is a column formula. The link would provide the end user with instant access to more detail if required. Ideally if anyone has a solution, the…
Using IF with Find
Hi, I'm trying to simplify a cell's contents, to allow better cross referencing and help eliminate issues with typos. I create cells with a serial number, someone requests that serial number though a form. Since the serial number can have a lot of variations requests through the form can have typos leading to the cross…