How to - Adding days to existing Date -

Dear ,

I need to add 4 days to ETA logistic column .Using simple formulae

However the result showing - Not correct

Both the column setting is DATE .

Please advice what am i doing wrong

Answers

  • Dan W
    Dan W ✭✭✭✭✭
    edited 07/14/22

    The Column Type must be date. I would double check the Type. By Right clicking on the column head and selecting "Edit Column Properties"

  • Matt Johnson
    Matt Johnson Community Champion

    Hi @Denny V

    I know you are stating that both columns are set to DATE but the only way I can replicate this is to have one or both columns set to TEXT/NUMBER. Maybe double check that, refresh, and then try the formula again.

    I hope that helps.

    Matt

    Matt Johnson

    DigitalRadius

    Smartsheet Platinum Partner

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!