Best formula?

Rachel Jonas

Hello,

I've tried searching previous similar questions but i think most are more advanced than I need:

I have a column which is a drop down with 2 options:

column name: 'Total people said 'YES' to Welsh at meetings'

option 1: At least 10% and less than 100% of attendees

option 2: Less than 10% of attendees

i want another column to auto populate based on which option was selected

column name: Send Email 02 or 03

above option 1: At least 10% and less than 100% of attendees auto populates Email 02

above option 2: Less than 10% of attendees auto polulates Email 03

Thank you in advance :)

Paul Newcome

Try this...

=IF(CONTAINS("At least", [Total people said 'YES' to Welsh at meetings]@row), "Email 02", "Email 03")

Rachel Jonas

thank you Paul, works perfectly :)

Paul Newcome

Happy to help. 👍️