Choose multiple checkboxes that will list each multiple box in library list

Question

IF box selected then status shown on page

No Box Selected 1.Verification
Verified 2. Security
Security 3. Pending IAO or Appointee
IAO or Appointee 4. Pending account creation
Account Created 5. Pending First Time Login

Each of these are yes/no columns in the listlibrary

This is the formula I tried to use to accomplish this request:

=IF(AND([Pending User Action]=True,"Denied/Pending User Action",IF(AND([Verified]=True,"Security", IF(AND([Security]=True, "Pending IAO or Appointee",IF(AND([IAO or Appointee]=True, "Pending account creation",IF(AND([Account Created]=True,"Pending First TimeLogin",IF(AND([First Time Login Complete]=True,"Completed",IF(AND([Completed]=True,"Completed"))))))))))))))

I would appreciate any help on this formula!

Regards,
James E

Answer 1

Hi @James Eggert ,

Welcome to Q&A Forum!

Please follow the steps:

1.Create the below Yes/No columns in the list, and set default value is "No".

• Pending User Action
• Verified
• Security
• IAO or Appointee
• Account Created
• First Time Login Complete
• Completed

3.Create a Calculated (calculation based on other columns) column. In my test, I named it [Test32]

4.Use the below Formula:

=IF(AND([Pending User Action]=TRUE,Verified=FALSE,Security=FALSE,[IAO or Appointee]=FALSE,[Account Created]=FALSE,[First Time Login Complete]=FALSE,Completed=FALSE),"Denied/Pending User Action",IF(AND([Pending User Action]=TRUE,Verified=TRUE,Security=FALSE,[IAO or Appointee]=FALSE,[Account Created]=FALSE,[First Time Login Complete]=FALSE,Completed=FALSE),"Security",IF(AND([Pending User Action]=TRUE,Verified=TRUE,Security=TRUE,[IAO or Appointee]=FALSE,[Account Created]=FALSE,[First Time Login Complete]=FALSE,Completed=FALSE),"Pending IAO or Appointee",IF(AND([Pending User Action]=TRUE,Verified=TRUE,Security=TRUE,[IAO or Appointee]=TRUE,[Account Created]=FALSE,[First Time Login Complete]=FALSE,Completed=FALSE),"Pending Account Creation",IF(AND([Pending User Action]=TRUE,Verified=TRUE,Security=TRUE,[IAO or Appointee]=TRUE,[Account Created]=TRUE,[First Time Login Complete]=FALSE,Completed=FALSE),"Pending First TimeLogin",IF(AND([Pending User Action]=TRUE,Verified=TRUE,Security=TRUE,[IAO or Appointee]=TRUE,[Account Created]=TRUE,[First Time Login Complete]=TRUE,Completed=FALSE),"Pending Completed",IF(AND([Pending User Action]=TRUE,Verified=TRUE,Security=TRUE,[IAO or Appointee]=TRUE,[Account Created]=TRUE,[First Time Login Complete]=TRUE,Completed=TRUE),"Completed!!","")))))))  

Thanks,
Echo Du

======================================

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.