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")))))