Need help with monthly form tracking formula to Master sheet


Intake Form sheet for each site that has submitted their monthly activity form. Entries will be in this sheet for the entire current year, so each site ‘might’ have up to 12 monthly entries.

Each of the 60 sites can have multiple entries, the 2 sheets are linked with Site ID (form sheet) Site # Text (master sheet)

If the [Month] column is equal to “6” I need a formula in the Master sheet to show “Complete” otherwise show as “Missing” for that month (Jun 2024)

Master Sheet, tracking each of the 60 Sites when/if they completed the monthly activity form

I’ve tried so many combinations of INDEX/COLLECT, INDEX/MATCH and nothing seems to work. Been searching the Community for days. Any help would be greatly appreciated! ❤️



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!