Employee Main List Formula Modification


I am currently using the Return to Workplace template set. I want to modify the formula being used on the Employee Main List Sheet to only collect trainings attended if the column next to it says a specific project phase (Dropdown). I am dividing the trainings by phases but I don't want the Trainings Attended to account for trainings for all phases since the "Attended Appropriate Training" formula would always show as "No".

The formula already implemented into the sheet is this one:

=IF(ISBLANK(JOIN(DISTINCT(COLLECT({EmployeeTrainings}, {EmployeeEmail}, [Employee Email]@row)), CHAR(10))), "No Trainings Attended", JOIN(DISTINCT(COLLECT({EmployeeTrainings}, {EmployeeEmail}, [Employee Email]@row)), CHAR(10)))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!