Add days to a date. Formula help

Options
This discussion was created from comments split from: Can't add days to a Date.

Answers

  • RT2
    Options

    Hi Kelly,

    I want to add the number in the 'Urgent Helper' column (in yellow) to the date shown in the 'date of request' column so that i get a future date in the 'Expected Completion Date'.



    I have been trying to do the same as Cemil and have the same problems. I have read that Cemil needed to format his column as a date.. I've checked mine and the destination column cell, the source cell and the feeder cell (from another sheet) are all set as date format. I can't figure this one out..

    Thank you in advance..

    Rich

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Options

    @RT2 How exactly are you populating the Urgency Helper column?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!