New to smart sheets

Brad LeBlanc

Good afternoon I am trying to take 2 columns, Date created and Days in pipeline and have it update daily so if I put a new sale in my pipeline on 4/20/2021 under the date created column I want it to update daily in the days in pipeline column. For example if today is the 28th it should show 8 as in 8 days in the pipeline. I have searched a million formulas but I keep getting error messages and I am soooo confused and frustrated. If anyone could explain in detail how to do this not just write the formula for me which would be great, but explain to me where to put what in each column with regards to the formula and how to have it work for every name I add to a new row. If anyone could help me I would be so grateful I am on a trial and want to pull the trigger because I really like this but I wanted to see everything I need first to make sure I can use it easily.

Joe Worthey

You can try using the TODAY() formula to provide today's date, and then subtract the value from the Date Created column. For example,

Type

=TODAY()-

and then click the cell within the Date Created column. Smartsheet will fill in the rest of the formula.

The formula in the Days in Pipeline column will be something like =TODAY()-[Date Created]@row

Make sure the Date Created column is a Date column type. Right click the column header and select Column Type and change it to a date type.

Here is an article about column types. They are important in Smartsheet and enable the tool to create reports, dashboards, and more things you cannot do in other spreadsheet tools.

https://help.smartsheet.com/articles/504619-column-types

Joe Worthey

You can set a formula for the entire column using Column Formulas

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Otherwise, you can "drag" the formula down to all other rows. Make sure your formula uses @row, for example [Date Created]@row. That tells the formula to use the cell value from [Date Created] on the same row.

Joe Worthey

You can try using the TODAY() formula to provide today's date, and then subtract the value from the Date Created column. For example,

Type

=TODAY()-

and then click the cell within the Date Created column. Smartsheet will fill in the rest of the formula.

The formula in the Days in Pipeline column will be something like =TODAY()-[Date Created]@row

Make sure the Date Created column is a Date column type. Right click the column header and select Column Type and change it to a date type.

Here is an article about column types. They are important in Smartsheet and enable the tool to create reports, dashboards, and more things you cannot do in other spreadsheet tools.

https://help.smartsheet.com/articles/504619-column-types

Brad LeBlanc

Wow that worked thank you how do I get it to work in every row now because it only worked in the 1 row that I put that formula?

Joe Worthey

You can set a formula for the entire column using Column Formulas

https://help.smartsheet.com/articles/2481944-set-formulas-for-all-rows-with-column-formulas

Otherwise, you can "drag" the formula down to all other rows. Make sure your formula uses @row, for example [Date Created]@row. That tells the formula to use the cell value from [Date Created] on the same row.

Brad LeBlanc

You are unbelievable I have been trying this for 2 weeks this was exactly what I wanted to do. I can't thank you enough that was truly so nice of you to help me. Thank you!