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.

Formulas

Options

Buffie Mcilwain

Buffie Mcilwain ✭

07/13/16 edited 12/09/19 in Archived 2016 Posts

I am trying to create a formula that will populate a date for me to ship orders 2 days prior to the start of a project. Can someone help me please?

Tags:

Construction

0 ·

Comments

Etienne Desbiens ✭✭

07/13/16
Options
=[Startoftheproject]1-2

Hope that helps!
Étienne

0 · Share on Facebook Share on Twitter
Buffie Mcilwain ✭

07/13/16
Options
Thank you it worked and I can see what I did wrong. Thank you again

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

New Sheet Not Showing up in Existing Report
I have a folder and inside the folder I have 25 sheets and a report that produced a listing of all the sheets in that folder, somehow when I add a new sheet in that folder, the new sheet doesn't listed on the report. Please help. thank you.
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
Simple Workflow Not Triggering
Hi, I have a very simple workflow set up using "TODAY()" date as a formula. Basically it's a tracker with due dates, and if a particular task is not "Complete" by the due date, the status will change to "Overdue". Let me emphasis that there are no external links on this sheet and the formulas work fine. The workflow is as…