IF AND AND OR

Debbie Priest

I have question in a grid asking

Is the Risk Assessment up-to-date? which is [Q6] with three drop down option being

Yes

No

We do not have Lone Worker Risk Assessments in place

To auto generate the next cell - need the responses activated as below

Yes - You have indicated that your Lone Working Risk Assessments are up-to-date, please ensure this is monitored on a regular basis.

No - You have indicated that your Lone Working Risk Assessments are not up-to-date, please ensure this action is completed immediately.

We do not have Lone Worker Risk Assessments in place -

You have indicated that you do not have Lone Worker Risk Assessments in place, a risk assessment must be carried out in all areas of work where working alone poses an actual or potential risk to staff.

I am struggling with the formula though, this doesn't work - =IF(AND([Q6]@row = "Yes", "You have indicated that your Lone Working Risk Assessments are up-to-date, please ensure this is monitored on a regular basis.", OR [Q6]@row = "No", "You have indicated that your Lone Working Risk Assessments are not up-to-date, please ensure this action is completed immediately.", "You have indicated that you do not have Lone Worker Risk Assessments in place, a risk assessment must be carried out in all areas of work where working alone poses an actual or potential risk to staff."))

Can anyone give any advice?

Bassam Khalil

Hi @Debbie Priest 

Hope you are fine, please try the following formula:

=IF([Q6]@row = "Yes", "You have indicated that your Lone Working Risk Assessments are up-to-date, please ensure this is monitored on a regular basis.", IF([Q6]@row = "No", "You have indicated that your Lone Working Risk Assessments are not up-to-date, please ensure this action is completed immediately", IF([Q6]@row = "We do not have Lone Worker Risk Assessments in place", "You have indicated that you do not have Lone Worker Risk Assessments in place, a risk assessment must be carried out in all areas of work where working alone poses an actual or potential risk to staff")))

Bassam Khalil

Hi @Debbie Priest 

Hope you are fine, please try the following formula:

=IF([Q6]@row = "Yes", "You have indicated that your Lone Working Risk Assessments are up-to-date, please ensure this is monitored on a regular basis.", IF([Q6]@row = "No", "You have indicated that your Lone Working Risk Assessments are not up-to-date, please ensure this action is completed immediately", IF([Q6]@row = "We do not have Lone Worker Risk Assessments in place", "You have indicated that you do not have Lone Worker Risk Assessments in place, a risk assessment must be carried out in all areas of work where working alone poses an actual or potential risk to staff")))

Debbie Priest

Thanks Bassam, the formula is now working, you are a star.

Bassam Khalil

@Debbie Priest

You are more than welcome and am glad to help you any time.