I am trying to create 3 Yes/No Fields and 1 calculated field in a SharePoint list. The calculated field will see if the 3 yes/no fields are filled out and will give it a result.
Create four different columns as in a list named Task 1, Task 2, Task 3 and Result. The result will be a calculated column.
If Task 1, Task 2, Task 3 are yes then the result=submitted
If Task 1, Task 2, Task 3 are no then the result=not submitted
If Task 1=yes and Task 2, Task 3 are yes then the result=delayed
I hope I didn't confuse anyone. Hope you can help. Thanks.