Need Help with a Formula for Checked Boxes and Forms

edited 04/05/24 in Formulas and Functions

Hello Smartsheets Community.

I'm trying to find the best formula for a checkbox to automatically checkmark once a form is submitted.

Please see below.

I have 5 Questionnaire Forms.

Then I have this sheet tracker

The Status Formula will already change to Completed and Green once the Submitted or N/A Checkmark is checked. I just need a formula to identify when a questionnaire form is submitted.

I was thinking maybe the IFERROR/VLOOKUP?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!