Hi, I need to have a list of audits that ha...

[Nick_Parsons]

Hi,

I need to have a list of audits that have been completed and within the list will be a field named “Date Due”. Date due is “Last audit” + Frequency (7 days) for example…Is this formula best added as an expression in appsheet or a formula in gsheets.

And, when an audit exists (having been created), and this audit has a due date, how is it possible to create a new audit to reset this due date as opposed to editing the existing one?

so a new audit record is created.

[Aleksi_Alkio]

Easier way could be if you just leave it as it is, and use the last due date with the MAXROW expression if you need to show the last one somewhere.