I created a smart sheet that notifies the appropriate lead when someone is requesting access to a project. All the formulas, filters, and alerts are correct. The issue I'm having is when a form is filled out a new row is created the formulas aren’t being placed in the appropriate cells so the notifications for leads would happen. Is there something I need to do to the form to get the formulas in the appropriate cell or do I need to change something in the sheet?
