Date-time math (e.g. DATEDIFF) is one of the most common Google Sheets formulas that people still rely on in their Glide apps, but as many of you know, relying on Google Sheets formulas can slow down your app, as Glide must wait for your Google Sheet to update, and then for Google to tell Glide about it.
When you do your date calculations in Glide, they update instantly!
Here you can see how we use this capability in one of our internal apps to calculate the age (in days) of ideas on our backlog:
Thanks so much! I need all the help I can get with setting up stuff like this. So cool that this feature is now available in Glide because I had just set up a DATEDIF function to track something. I just need help setting it up because it’s somewhat confusing for me on the Glide end.