HELP - FORMULA - equal to AND IF/THEN

Final Decision (WEBFORM) is a hidden column with the webform results in Yes, No, Hold symbols

I need a combination formula for "Final Decision" column:

1. To equal the results in "Final Decision WEBFORM" column

2. AND IF "Final Approval" Column is checked, then show "Yes"

Find more posts tagged with

Forms

Manufacturing

Sheets

Formulas

This is what I've come up with thats working. If you think there would be a better formula please let me know.

=IF([Final Approval]1 = 1, "Yes", [Final Decision (WEBFORM)]1)

Thanks!

*I love how much everyone here has helped improve my formula creating skills

That would seem to do the job. Good work!