Tracking that updates are received from employees


I have created a sheet for employees to provide numeric updates at 10AM, 2PM, and EOD.

On a separate sheet, I am trying to create an automatic checklist to ensure all updates are received and that will send reminders if their update is missing. My checklist looks like this:

I have used this formula on a checklist for just checking that the employee's name is present on the update and that works great.

=IF(COUNTIFS({Employee}, Employee@row) 0,1)

However, I cannot figure out how to have it check both the name and the column. Any suggestions?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!