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.