Add days to a date. Formula help

System

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

RT2

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

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

RT2

Hey Paul, They are added via an automation triggered from the given 'Required Completion Time'

response

Andrée Starå

https://community.smartsheet.com/discussion/comment/432874#Comment_432874

Hi,

I hope you're well and safe!

Can you share screenshots of one of the Workflows? (Please delete or replace any confidential or sensitive information before sharing.) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅ Did my comment help or answer your question? Please support the Community and me by marking it 
💡 ⬆️ ❤️ or/and as the accepted answer. It will make it easier to find a solution! Thanks!

Paul Newcome

@RT2 Can you provide a screenshot of one of the automations? Also… You have checked that the date columns in question are all date type columns, but how is the original source data being populated exactly?

RT2

Hi Paul, I've took a new approach on this, but come up against another, more simple, problem…

https://community.smartsheet.com/discussion/122432/simple-or-not-so-simple-subtraction-formula-needed

Paul Newcome

@RT2 I have responded on the other thread.