Auto Calcuate Due Date Formula

I am trying to calculate a due date based upon a 5, 15, 30 day criteria. The problem I am running into is that the way I have the 1st row of each area setup (it is broken down by equipment, then sub categorized into dates).

I have a formula setup to auto calculate the # of days criteria based upon "low, medium, high" priority.

I want the due date to auto calculate based upon "5, 15, 30" days from the created date, but when I do so, it throws a weird date in the due date column.



Tags:

Answers

  • Danielle Arteaga
    Danielle Arteaga ✭✭✭✭✭✭

    Hi, @Austyn Lynch - is your [Date Reported] column set up as a Date column type or a Text/Number column type? (You can tell by looking at the column preferences.)

    To use date-based formulas, your target and result cells have to be formatted as date-type columns, which might explain why you're getting the odd result in your [Due Date] field.

    If your columns are correctly formatted, can you please share the formula you have in the [Due Date] column?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!