Any Suggestions?

MichaelSmith1726

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.

Data Sheet.PNG

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.

Master Sheet.PNG

L_123

Try

Index(collect())

and/or

Join(collect())

If you need more help I can go into more detail

L_123

=if(contains("OPSEC",[Completed Training(s)]@row,1,0)

Give that a try

L_123

Try

Index(collect())

and/or

Join(collect())

If you need more help I can go into more detail

MichaelSmith1726

@L@123

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?

L_123

=if(contains("OPSEC",[Completed Training(s)]@row,1,0)

Give that a try

MichaelSmith1726

@L@123

Works Perfectly!!! You are awesome! Thank you so much for all your help and quick response!