New to smart sheets

Options

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.

Best Answers

  • Joe Worthey
    Joe Worthey ✭✭
    edited 04/28/21 Answer ✓
    Options

    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
    Joe Worthey ✭✭
    Answer ✓
    Options

    You can set a formula for the entire column using 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.

Answers