Sheet summary formula to return first value above 0
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.
Best Answers
-
Hi @Vincent Baccari,
Give this a try.
=MIN(COLLECT(Countdown:Countdown, Countdown:Countdown, >0))
Hope this helps,
Dave
-
Here you go.
=IF([ART Start Date]@row - TODAY() < 0, 0, [ART Start Date]@row - TODAY())
Dave
Answers
-
Hi @Vincent Baccari,
Give this a try.
=MIN(COLLECT(Countdown:Countdown, Countdown:Countdown, >0))
Hope this helps,
Dave
-
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())
-
Here you go.
=IF([ART Start Date]@row - TODAY() < 0, 0, [ART Start Date]@row - TODAY())
Dave
-
Appreciate you @DKazatsky2! Both of these worked flawlessly!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66K Get Help
- 429 Global Discussions
- 149 Industry Talk
- 488 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!