Any Suggestions?

06/15/20
Accepted

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

  • L_123L_123 ✭✭✭✭✭
    Accepted Answer

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

    Give that a try

Answers

  • @[email protected]

    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_123L_123 ✭✭✭✭✭
    Accepted Answer

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

    Give that a try

  • @[email protected]

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

Sign In or Register to comment.