Formula for Start and End Dates in a column
I'm trying to create a Sheet Summary formula to return the first date in a column and keep getting errors. I can't seem get it to look at the entire column or even a range. I've confirmed the reference columns are all Date columns. Here is the formula I'm attempting and the error I'm receiving.
Best Answer
-
@BettyJo Hi, Have you tried changing to a Date field instead of text?
Answers
-
Hey @BettyJo,
The sheet summary field needs to be a date field, the formula should work then :).
Hope this helps!
If my response was helpful in any way (or answered your question) please be sure to upvote it, mark it as awesome, or mark it as the accepted answer!
I'm always looking to connect with other industry professionals, feel free to connect with me on LinkedIn as well!
-
@BettyJo Hi, Have you tried changing to a Date field instead of text?
-
-
Thank you, that helped!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!