1

I have searched and searched the web for the answer but nothing I try seems to work in these SharePoint calculated columns, basically, I have a column called Email Sign Off and another called Equipment Sign Off, they are both Yes / No Columns. User Status (calculated column where the results will appear)

what I want to happen is if both columns are empty the User status to say "Not Started" When either Email Sign Off or Equipment Sign Off are True the User Status to say "In Progress" if both columns are True then the User Status to say "Complete"

I have tried several code examples, after trying my own but the results do not come out as they are meant to or SharePoint tells me the code is wrong. From my limited programming knowledge I'm used to using ELSE, &&, OR but these do not seem to work even though others have given examples including AND, OR, but apparently ELSE doesn't exist.

=IF([Email Sign Off]=TRUE,IF([Equipment Sign off]=FALSE,"In Progess",IF([Email Sign Off]=FALSE,IF([Equipment Sign off]=TRUE,"In Progess 2",IF([Email Sign Off],[Equipment Sign off]=TRUE,"Complete")))))

Results to the code above

Improve this question

1 Answer 1

Reset to default
0

Try using this formula:

=IF(AND([Email Sign Off], [Equipment Sign off]), "Complete", IF(AND(NOT([Email Sign Off]), NOT([Equipment Sign off])), "Not Started", "In Progress"))

Note:

  1. Sometimes comma(,) does not work in formula (I am not sure but it is based on something language or regional settings on your site). So in that case use semicolon(;) instead of comma(,).

Output:

enter image description here

Improve this answer
7
  • Hi and thank you for attempting to help but even though the code was excepted, the desired results did not appear
    – Michael Powis
    Oct 18, 2022 at 10:31
  • Try using updated formula in above answer.
    – Ganesh Sanap
    Oct 18, 2022 at 10:44
  • for some reason every version works except if Email Sign Off is TRUE and Equipment Sign Off is FALSE then it displays as complete.
    – Michael Powis
    Oct 18, 2022 at 10:47
  • Can you confirm if Equipment Sign Off is actually FALSE or just "empty"? Try adding filter on this column to check if there are any empty values.
    – Ganesh Sanap
    Oct 18, 2022 at 10:53
  • 1
    Hi Thank you that worked, i went through the rows with existing data and ticked all the boxes and then unchecked the ones to see the results and now it's working as you described
    – Michael Powis
    Oct 18, 2022 at 11:10

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.