Formula for multiple column Checkmarks or N/As as a value?

tkearney

Hello,

I am not getting any headway on a IF formula. I have multiple columns that use the values Checkmark and N/A in a drop down column. Its not a checkbox column. The checkmark is a icon that shows a green checkmark in the cell.

I have another column that I want to have a formula that says if all these columns have a Checkmark AND/OR N/A, then this column will say "Complete".

tkearney

To add some additional context, I am trying to figure out what the formula look like because some of the drop down values are Emojis (check marks, red x, and N/A)

Andrée Starå

Hi @tkearney

I hope you're well and safe!

Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

tkearney

The formula I got to that is saying #UNPARSEABLE is below....

=IF(OR([Loan Type Entered Correctly]@row = "Yes", [Loan Type Entered Correctly]@row = "N/A", [HMDA Complete]@row = "N/A", [Loan Documents Signed]@row = "N/A", [Loan Package Imaged]@row = "N/A", [Supporting Documents Imaged]@row = "N/A", [Smartsheets updated]@row = "N/A", [Annual Review Tracking Complete]@row "N/A", [HMDA Complete]@row = "Yes", [Loan Documents Signed]@row = "Yes", [Loan Package Imaged]@row = "Yes", [Supporting Documents Imaged]@row = "Yes", [Smartsheets updated]@row = "Yes", [Annual Review Tracking Complete]@row = "Yes"), "Complete", "In Progress")

I changed the checkmark emoji and red x emoji to simpler text values for the drop down.

There are 7 columns and each column has (Yes, No, N/A) as the possible values.

If a team member chooses Yes or N/A for each column, then that task is considered complete. If it is blank or says "No", it is considered in Progress.

All 7 columns must say Yes or N/A in order to be considered "Complete".

Its data sensitive so I am not able to share any screenshots because there is NPPI involved.