Hi there,

I have a SharePoint list where the columns are Create Date, Request #, and 5 employee names.  Each employee goes into the list and marks if he or she has completed the request, or not.  

What I Want: I want to add a column titled “Status” where it will automatically fill in the words “Selections Complete” when all 5 employees have made a selection.  If possible, also send an email to a recipient of my choice.  It doesn’t matter if they choose Complete or Not – all that matters is that they have made a selection of Complete or No.

Is this possible?  I understand the list I made is a little bit unorthodox with each employee being a column.

Thanks.

​Hi there, I have a SharePoint list where the columns are Create Date, Request #, and 5 employee names.  Each employee goes into the list and marks if he or she has completed the request, or not.   What I Want: I want to add a column titled “Status” where it will automatically fill in the words “Selections Complete” when all 5 employees have made a selection.  If possible, also send an email to a recipient of my choice.  It doesn’t matter if they choose Complete or Not – all that matters is that they have made a selection of Complete or No. Is this possible?  I understand the list I made is a little bit unorthodox with each employee being a column. Thanks.   Read More

​