Auto-updating of Age

[Cyrus]

Hi Everyone,

Is there a way to automatically update a column, e.g. Age? 

Age (Column) = Today()-[Birth Date] / 365.25

I notice that the computed "age" is "unchanged" even after some time passed by. 

Hope someone can help and enlighten me.

Thank you!

[TeeSee1]

See this Q&A

https://www.googlecloudcommunity.com/gc/Feature-Ideas/Ability-to-refresh-a-table-s-columns-with-the-...

Added:

https://support.google.com/appsheet/answer/10106437?hl=en

[Ceke]

To automaticly update the age you have 2 ways.

1) with automation if your app is deployed you can set a behaviour "set value for some column" for the formula of your age.

2) using a Google sheets formula. When the formula is on the sheet it will update automaticly.

[Kabuliño]

ok, you can create a virtual column or use a real column of your table with a formula like yours or similar to this

FLOOR(HOUR(TODAY()-[Birth Date])/365/24)&" years "&
FLOOR(MOD((HOUR(TODAY()-[Birth Date])/24),365)*12/365) & " months"

In my case, to update the age, I use an action that helps me display the "details" by changing the value in one of my columns from false to true, and modifying that row updates the age.

[ChristhianMoren]

Hola Ciro, lograste encontrar la manera de actualizar automáticamente la edad?

Ya que yo tengo el mismo problema, agradeceré me apoyes!.

Saludos.