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.