Please help me convert an Excel formula into a Smartsheet formula
Answers
-
How exactly does the new column impact the logic? Is it that OO should go to the next OO, TT should go to the next TT, so on and so forth?
-
Yes, precisely! It didn't seem to make a difference in Excel because it showed the dates correctly so I didn't think to include it. But, I wanted to share incase it helps fine tune the formula for Smartsheet.
For example, after WW's Session 2, their next session is 10/3. But the most recent formula shows 10/2. And its more apparent in the green section.
Thank you :)
-
It does make a difference. Lets try this one:
=MIN(COLLECT([Training Date]:[Training Date], Session:Session, @cell> Session@row, Team:Team, @cell = Team@row))
-
YES!!!! That gave me exactly what I was looking for!!! Thank you so much for helping me, you're amazing!!!
-
Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
