I would like to insert a new blank row when there is a value in a certain
colum of our spreadsheet.

How can I insert the row automatically after the row where the condition is
satisfied.

for example.... =IF(a1=popcorn,yippie,"insert a blank row below a1...")

How the heck do I do that?