I have an employees table that needs to updat...

(Pete Morales) #1

I have an employees table that needs to update daily. I have a DAYS , MONTHS, and YEARS columns. These need to update based on my STARTED date column, I know the formulas for these columns. I need help in having my app update my table on a daily basis or at least when the app opens up. Is this possible?

(Aleksi Alkio) #2

Without knowing your app/spreadsheet structure, I would say you need to use virtual column for those values.

(Bellave Jayaram) #3

VCs do not get saved to the sheet but you can always make a real column equal to the VC by putting [VC] in the app formula for the real column. If you are wanting to do this without opening the app, then you can do it using sheet formulas or if more complex changes in other tables need to be made, a time triggered script (assuming you are using Google spreadsheet)