Formula Needed For Combining Rows with Exact Values in Separate Sheet


Hello Smartsheet Community,

I have a compliance tracker sheet that captures employee's HIPAA and FEMA certifications. I have been tasked with creating a dynamic view for their immediate supervisors. I have two separate views for FEMA and then HIPPA. However, I also have employees who have submitted separate reports for each individual FEMA module. And I would like in the dynamic view for these individuals to only appear once, however I am seeing an individual appear 5x (even if they have only 4 FEMA rows), there HIPPA row will appear too. So is there a formula or some type of way (whether creating a separate sheet/or running the view through a report) for me to combine these separate cells/rows into one row when the same individual submits multiple forms.

Thank you in advance,


Public Health


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!