Subtracting Days from a Date

Hello,

I am trying to subtract 30 days from a column pulling in dates from another sheet using formulas and it keeps yielding an #INVALID OPERATION error. I have already checked and do not have dependencies enabled. Both columns are formatted as date columns. While playing around I noticed when I add the days it instead tacks the number to the end of the year. How do I correct this?

Formula/function needed but causing error: =[Target Activation Date]@row - 30

Formula discovered just tacking number onto the end of the year instead of adding days: =[Target Activation Date]@row +30 (Picture for reference)

30

Tags:

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    The current formula will pull date values if the source data is date values.

    If one of the columns is not showing the calendar (when no formula is applied), it is not set as a date type column.

    How is the source data being populated?

    Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!

    CERTIFIED SMARTSHEET PLATINUM PARTNER

    10xViz.com

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!