App formula (time diffrence) update every sync

AppSheet AppSheet Q&A
1

Hi I use Time diffrence formula to calculatie how long some tasks take.
IF
(
ISBLANK([End Date]),
HOUR(NOW() - [Start Date])/24,
HOUR([End Date] - [Start Date])/24
)

Forumla works great and give mi days in Dicemal bettween
Now and Start Date
or if someone fill End Date beetween End Date and Start Date

Problem is it recalculated only if update row
I want to see that update every sync

How to do that ?

Should I put that formula in Excel insted of Appsheet ?

2

Szymon_Hajduk:

I want to see that update every sync

Then it needs to be a virtual column.

3

Not good I want to see that data in my Database (Excel Tabel)

I try the same formula in Excel and it’s update every time when sync

I don’t now how it will work in future with more data ? I know that Appsheet formulas are faster then Excel so I try to avoid Excel Formulas.

4

AppSheet will not update physical columns on sync; there is no way to do what you want through AppSheet.

5

Thanks Excel solve the problem

1 Like