#### 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
edited 12/09/19

I have two cases where I need a formula to work for me

The first one is easy.  I have two columns - Delivery Date and Delivery Date (2).  I want Delivery Date (2) to automatically put the same date that is in Delivery Date in the corresponding cell.  I tried =[Delivery Date]1 but I get an error that says #number expected.  What does that mean?

Next question:  we create and send multiple deliverables before during and after a launch.  When we begin planning we create a T schedule where "T" is our go live date.  Then every deliverable is assigned a T + or - (in weeks).  So for example, if July 2 2016 is the date the system goes live, we may know that we want our field managers to know about the system go live date two weeks prior to launch (or T-2).

I have two columns: T+/- and Due the week of.  I would love for my sheet to understand what T is and then when the T+/- field is filled in with "T-3" or "T+3"), the Due the week of column is auto calculated.  Is that possible?

• ✭✭✭✭✭✭
Options

Kneve,

1. Change the column type to "Date". The system is telling you it expects a number because Delivery Date (2) is a Text/Number type.

2. As long as [Due the week of] column is not a Project Dependency, you should be able to do that.

Does the date need to be "T-3" instead of just "-3"? Isn't the T implied in the column name?

If you are calculating [Due the week of], where is the base date?

For [Due the week of]

=[Whereeveryourbasedatecolumnis]23 + [T+/-]23

for row 23 would work (I assume haven't tested with those special characters, but I assume so)

If you need to strip out the '"T", check out the RIGHT function and the VALUE function.

Hope this helps.

Craig

• ✭✭✭✭✭✭
Options

Kneve, I told you there was a user named Craig who would know all of the answers - he's SO helpful!

• ✭✭✭✭✭✭
Options

Jaye, you will make me blush.

Craig

• Options

Thanks guys!

This discussion has been closed.