Max if
![Samuel Dowdy Jr.](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Samuel Dowdy Jr.
✭✭✭✭✭✭
=MAX([Month - Count]:[Month - Count], IF([Month Closed]:[Month Closed], 1))
I know Im way off on this formulas, but what I am trying to do is reflect the month that is currently closed. Month Closed is a checkbox. Im trying to collect the most recent or max month count if the month is closed is checked.
Best Answer
-
=MAX(COLLECT([Month - Count]:[Month - Count], [Month Closed]:[Month Closed], @cell=1))
Answers
-
=MAX(COLLECT([Month - Count]:[Month - Count], [Month Closed]:[Month Closed], @cell=1))
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 469 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 148 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!