JOIN and COLLECT with multiple criteria and date - cross sheet reference


I have a sheet that uses a web form to gather data from multiple users across the fleet. The idea is for the managers to submit their site information each week on Tuesday. I have another sheet that is formatted vertically that will push out an automated alert to the executives at the end of business on Tuesday evening. The alert will summarize all entries submitted from the form for the current week only. I can't figure out why it isn't working, what am I missing??

(Sheet populated by webform)

(Sheet with formula and alert workflow to executives)

=JOIN(COLLECT({Safety, Security, Environmental}, {Plant / Site}, "New England Peaking", {Date}, "TODAY"))

Best Answer