Any Suggestions?
Hello,
I am trying to find a formula to pull information submitted from forms to a master sheet. We are attempting to use Smartsheet to keep track of training requirements for different projects within our company. Some of these projects may have to multiple trainings that they have to complete each Option Year. I have attached a screenshot of the Data sheet for the form submissions.
How do I take these multiple entires and combine them into one row on another sheet to show if they have completed all their required trainings for that year? Most the formulas I have tried stop once they see the identifier and do not continue to search. Below is the Master Sheet I have created, but I am open to any other suggestions/changes.
Best Answers
-
Try
Index(collect())
and/or
Join(collect())
If you need more help I can go into more detail
-
=if(contains("OPSEC",[Completed Training(s)]@row,1,0)
Give that a try
Answers
-
Try
Index(collect())
and/or
Join(collect())
If you need more help I can go into more detail
-
This was very helpful and has me moving in the right direction. I was able to have the trainings now show in one row. Do you know of a way that I can now have the checkbox be flagged for the training?
-
=if(contains("OPSEC",[Completed Training(s)]@row,1,0)
Give that a try
-
Works Perfectly!!! You are awesome! Thank you so much for all your help and quick response!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!