Creating an IF statement for multiple options in a Field

Question

I'm new to coding so I'm a bit out of my depth.

I have a "Multiple Select" field and I'm trying to create a new field which counts how many selections were made for each record.

The items are given a rating depending on how many selections they can tick.

I have the below but I'm certain I'm making lots of very basic errors.
Any suggestions would be greatly appreciated.

{Sustainability Rating} = "n",

(("n" = 0)

IF({Sustainability Checklist}, "Is the item plastic free?", "n"+1),
IF({Sustainability Checklist}, "Is the item made from recycled material?", "n"+1),
IF({Sustainability Checklist}, "Is the item fully recyclable?", "n"+1)
)

bruceconsulting · Accepted Answer

Hi,You would think it would be an IF formula, but it's not. Here's the formula you want:IF({Sustainability Checklist},LEN({Sustainability Checklist})-LEN(SUBSTITUTE({Sustainability Checklist},",",""))+1)If you want to talk about this further or if you ever need additional help, please schedule some time with me.  Here's my Calendly link: https://calendly.com/d/ymz-t3t-fnp/30-minute-help-meetingJody

jamiepjordan · Answer

Hi,You would think it would be an IF formula, but it's not. Here's the formula you want:IF({Sustainability Checklist},LEN({Sustainability Checklist})-LEN(SUBSTITUTE({Sustainability Checklist},",",""))+1)If you want to talk about this further or if you ever need additional help, please schedule some time with me.  Here's my Calendly link: https://calendly.com/d/ymz-t3t-fnp/30-minute-help-meetingJody  Thanks so much Jody.I'll have a play with this tomorrow and let you know how I get on.Much appreciated.J

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded