GoogleSheetsV2API logoGoogleSheetsV2API logo

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. ”

Bryce Vernoncreated by Bryce Vernon

This Zap uses a private app.

This means the developers of this app haven’t completed our full quality assurance steps. Zapier has limited details on this app and as a result can’t offer support for it. If you have questions about this app, please contact the person who gave you access to this Zap.
How Zapier works (57 sec)
How Zapier works (57 sec)
Try this Zap FREE for 14 days

Trusted at companies large and small

This Zap works in 2 steps …

  • Step 1 - Trigger

    Anytime a new spreadsheet row is created in Your App

    1 note from the creator …

    1. Bryce VernonBryce Vernon (creator)Make sure your use this same Google Sheet when you create your Glide app.
  • Step 2 - Action

    Update spreadsheet row in Your App

    2 notes from the creator …

    1. Bryce VernonBryce 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
    2. Bryce VernonBryce 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()
    • 1 minute to set up
    • Get back 1.2 hrs /week
    • 3 people use this zap

    This Zap uses the following app

    • Google Sheets (Deprecated) logo

    Google Sheets (Deprecated)

    Check out all the other ways you can connect Google Sheets (Deprecated).
    Learn More