New Date in Glide → update the row with formulas in Google Sheets

“When you add a new date in your Glide app, a new row is added into the Google Sheet. This Zap triggers when that new row is added. Then, the action step is to update that newly created row by inserting two formulas into the "current years" and "days to go" columns. ”

created by Bryce Vernon

How Zapier works (57 sec)

Try this Zap FREE for 14 days

Bryce Vernon (creator)Make sure your use this same Google Sheet when you create your Glide app.

Bryce Vernon (creator)The current years formula (in case it doesn't populate) is: =(NOW()-A{{map in the row id from the trigger}})/365.25
Bryce Vernon (creator)The days to go formula is: =IF(DATE(YEAR(TODAY()),MONTH(A{{map in the row id from the trigger}}),DAY(A{{map in the row id from the trigger}}))>TODAY(), DATE(YEAR(TODAY()),MONTH(A{{map in the row id from the trigger}}),DAY(A{{map in the row id from the trigger}})), DATE(YEAR(TODAY())+1,MONTH(A{{map in the row id from the trigger}}),DAY(A{{map in the row id from the trigger}}))) -TODAY()

Check out all the other ways you can connect Google Sheets.