Tracking that updates are received from employees

Options

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?

Tags:

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!