1

How to Fix your problem Manually install the onFormSubmit trigger. When installing the Trigger, under "Choose which function to run", choose the function onFormSubmit (the trigger event argument () isn't shown when creating the trigger. There should only be one onformSubmit trigger, and only function executed by the trigger. If you find that the function ...


1

You could use the following formula in cell D3 (or anywhere else you may need to). =IF(AND(REGEXMATCH(B3, ","),C3="none"), "USA","Oops") (Of course you can change "Oops" to whatever you like or even a blank cell"")


Only top voted, non community-wiki answers of a minimum length are eligible