Sheet summary formula to return first value above 0

Vincent Baccari

Seeking a sheet summary formula to return the first value above 0 for "Countdown" column. This value will be displayed as "Countdown to next launch" in a dashboard.

DKazatsky2

Hi @Vincent Baccari,

Give this a try.

=MIN(COLLECT(Countdown:Countdown, Countdown:Countdown, >0))

Hope this helps,

Dave

DKazatsky2

@Vincent Baccari

Here you go.

=IF([ART Start Date]@row - TODAY() < 0, 0, [ART Start Date]@row - TODAY())

Dave

DKazatsky2

Hi @Vincent Baccari,

Give this a try.

=MIN(COLLECT(Countdown:Countdown, Countdown:Countdown, >0))

Hope this helps,

Dave

Vincent Baccari

Amazing! Thank you @DKazatsky2! Follow-up Question: How would I get the countdown column formula to stop at 0 instead of displaying the negative values. My current formula is:

=([ART Start Date]@row - TODAY())

DKazatsky2

@Vincent Baccari

Here you go.

=IF([ART Start Date]@row - TODAY() < 0, 0, [ART Start Date]@row - TODAY())

Dave

Vincent Baccari

Appreciate you @DKazatsky2! Both of these worked flawlessly!