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?



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!