Array formulas


I was looking for using array formula functionality in smart sheet.

I need this because i saw that like this i can full fill what i need.

Any case, could you please mention if is a way to use array or other solutions in order to perform:

- I want smart sheet to show me in a column date, the first date, closest that will happen in the future.

(in my example i used  MIN(date) but is not ok)

- I want that  where the Status will change to "Done", smart sheet not to take care about that date, and to show me the next closest date. That will be my next D-day to take care of it.


Would be wonderful and appreciate a lot your support in this.

Thank you!





Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!