Delinquency Report

Avani

Hi SmartSheet Community,

How do you pull a delinquency report showing month to month stagnation, in the same column across sheets? I'd like to send a monthly update request form for the "assign to" with their lists and pull only those item's whose %complete hasn't been updated in the last 30days. Is there a column specific "last updated" formula that can be referenced as a condition within the form?

TIA for your help with this and being open to showing where you have been able to apply this.

Paul Newcome

You would need to use a Record A Date automation to grab the date the % Complete column was last updated.

Paul Newcome

You would need to use a Record A Date automation to grab the date the % Complete column was last updated.