Date combined in a cell
Some fabulous person helped me previously with putting 2 dates together in one cell on a sheet summary.
I am now trying to do the same thing within my sheet. There are details in child rows I dont necessarily want to share with client, so Ive moved those items to a row Ive designated "project level" to move all client facing updates there.
One item is a timeframe listed in the project plan Id like to populate in a cell on only the "project level" row
=(LEFT[Start Date]108,5) + "-" + LEFT(Due Date108,5
How do I now remove the time and just have the dates
Answers
-
=dateonly([Start Date]108) +”-“+dateonly[Due Date]108)
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
Hi , I appreciate the help but it is not working :( getting "UNPARSEABLE"
-
I am sorry. There was an error in the formula I posted. So if you copied and pasted it directly It would not have worked. In this one i corrected the error. I forgot to close off the second dateonly() function.
=dateonly([Start Date]108) +”-“+dateonly([Due Date]108)
Dateonly function also only works on system columns. "This Includes Start and end dates in project forms".So if your not pointed it to a system column then it wont work either. What type of Column are you pulling the dates from? IF it just has a date and not a time stamp. That would change the formula.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
This is perplexing me. The example image I showed it worked with no issues. I aa willing to delve deeper into this if you would like to contact me on teams.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
@Mark.poole I would love to connect , I have a presentation at 4 Id love to get this fixed ahead of. How can I reach you?
-
@AmandaB23 You can reach me on teams if you use it. Mark.poole@whirlwindsteel.com.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.3K Get Help
- 364 Global Discussions
- 199 Industry Talk
- 428 Announcements
- 4.4K Ideas & Feature Requests
- 136 Brandfolder
- 127 Just for fun
- 128 Community Job Board
- 445 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 283 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!