Formula to obtain upcoming deadline
Hello! I am working on getting a widget on a dashboard to show the next upcoming deadline, automatically pulling this information from the below sheet, analyzing the 3 date columns. I've tried several COLLECT formulas but nothing seem to work. Any ideas?
Answers
-
-
Hello @Kelly P. I tried that, but it is giving me #INVALID COLUM VALUE - both columns are date columns... but I think it is possible to apply these formulas with date columns that's why I am confused!
-
In my sheet, I have 3 date columns (W-2, W+1, and W+4). In a 4th date column, I have the formula (although it would probably make more sense to put the formula into a date field in the sheet summary). I've included a couple of screenshots. Perhaps you could post some screenshots?
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!