Formulas and Functions
Formulas and Functions
Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.
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!!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 466 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 520 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- In Sheet 1, I have a drop down column called [Status] and a contact column called [Program Developer]. In Sheet 2, I want to write a formula that counts the number of times (or rows) in which Email@ro…
- QUESTION: How to create a Text string output from a formula that can be copied and pasted into other applications. BACKGROUND: I have a large project that requires many Discovery sessions and have a s…
- I currently have this formula working to return the Store number that is Type - TRH. =INDEX(COLLECT({Copy of Construction-Checklist STORE NUMBER}, {Copy of Construction- TYPE 3}, "TRH"), Number@row) H…
