Help With Dates If Certain Criteria are met

ed_2868

Hi I am trying to work out how to Auto work out overdue date 

See attached i would like to get my Site Audit Complete column when marked "yes" to calculate the "Site Audit HN Dead Line" column's date continually move my overdue date to the current date each day until column marked Site "Audit approved" is marked Yes 

Is there a simple way to do this ? any help on this matter would be greatly appreciated 

Thanks 

Mike Wilday

I'm sorry, but this is not currently possible. Have you considered have the Site Audit completed column be a date column instead? Then when the audit is complete you could have the date automatically set from the date that was entered in the site audit column. For example, if the Site audit was completed today, 1/9/2019 - you could have them enter the date indicating its complete, then use a formula like =Iferror([Site Audit Completed]@row + 30, "No Audit Date" ) to add 30 days to the site audit date for a due-date or display "NO Audit Date" if there is no date in the site audit column. 

Just a thought. IF you'd like to request the ability to calculate the date an item was changed or edited, please submit a product enhancement request.