How to I implement a formula into a cell?

Garrett Baker

How to I implement a formula into a cell? 

Andrée Starå

Hi @Garrett Baker

Not sure I follow.

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Jemari

Start by inserting your cursor into the cell and type the equal sign: =. After that, it all depends on the kind of formula you need, so either ask here with more detail, or google it with more detail. Good luck!

Garrett Baker

I am trying to back in to a date based on another date.

For each project we have an Anticipated Deliver Date, I need to back track 90 days from this anticipated delivery date for our Metal Building Delivery Date. That automation is what I am trying to achieve. Can we screen share or hop on a phone call? Thanks.

Andrée Starå

@Garrett Baker

Are the dates on different rows? If yes, you could use the Dependencies feature.

Make sense?

Would that work/help?

Garrett Baker

Yes, the dates are on different rows. I would like to enter the Anticipate Delivery Date and have the Metal Building Delivery Date automatically generate. I am not familiar with the Dependencies feature, how to I activate this feature?

Andrée Starå

@Garrett Baker

Here's more information about the Dependencies feature.

https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!