Formula to obtain upcoming deadline
SofiRuiz
Overachievers
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?
Tags:
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 (W2, 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
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!