Comparing Cell Contets

Vuckecucke

Comparing Employee names from FORM (no sign in required) in sheet with the Employee contact list Formula ? I have a master sheet that gathers: training Name and attendees names. i will like to generate the list of who did not attended the training.

What is the best function to use for this?

Many thanks,

AravindGP

Hi @Vuckecucke

You will need to write a formula in your Master sheet. You can use this. =IF(HAS({Column reference of the employee name column from the sheet linked to the form}, [Employee name column in your master sheet]@row), "Attended", "Not Attended")

This will look up each employee name in your master sheet against the list of names in your other sheet with the form entries and mark as attended if the name appears and not attended if it doesn't. You will need to click on Reference another sheet to create the cross-sheet reference

AravindGP

Hi @Vuckecucke

You will need to write a formula in your Master sheet. You can use this. =IF(HAS({Column reference of the employee name column from the sheet linked to the form}, [Employee name column in your master sheet]@row), "Attended", "Not Attended")

This will look up each employee name in your master sheet against the list of names in your other sheet with the form entries and mark as attended if the name appears and not attended if it doesn't. You will need to click on Reference another sheet to create the cross-sheet reference

smartsheetrr

To track who didn't attend training, first, collect attendees' names using COLLECT in your Smartsheet. Then, compare this list with your Employee contact list using NOT(CONTAINS()). This formula checks if each employee from the contact list is in the attendee list. If not, it marks them as "Not Attended." You can then filter or create a report to display only those who missed the training. This way, you quickly identify who didn’t show up using Smartsheet's built-in functions.

Vuckecucke

thank you!

Vuckecucke

@AravindGP

it works!

Vuckecucke

How would i include multiple ranges from different sections of the sheet, row cells ?