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.

Date Formula

Options

Zoe McInerney

Zoe McInerney ✭

04/09/17 edited 12/09/19 in Archived 2017 Posts

Hi. I have finish dates for tasks and need to start them 120 days prior to that. How would I write that formula. Thank you!

Tags:

Formulas

0 ·

Comments

Adam Overton Employee

04/10/17
Options
=[Finish Date]2 - 120

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

How to count unchecked boxes for rows with data only
I tried this formula but it's also counting the unchecked rows without data =COUNTIFS([Client Lost?]:[Client Lost?], 0) What should be the correct formula?
Risk Rating Formula
Hi all - I am trying to create a long formula and need some assistance. For a Risk tracker I have 2 columns (Probability and Impact) both which have list values of High, Medium, Low. Based on those selections I want to have a 3rd column which is the output of the formula, Rating, designated High, Medium, Low. Below are the…
Trouble Reaching Smartsheet - errorCode: 63
Hello all - We have a sheet that is refusing to save. Each time we try, we receive the following message. Anyone have any ideas on how to resolve this? Thank you!