Add days to a date. Formula help
Answers
-
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
-
@RT2 How exactly are you populating the Urgency Helper column?
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!
-
Hey Paul, They are added via an automation triggered from the given 'Required Completion Time'
response
-
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!SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@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?
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!
-
Hi Paul, I've took a new approach on this, but come up against another, more simple, problem…
-
@RT2 I have responded on the other thread.
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!