Help with date formulas

I’m very formula challenged…

I run a halfway house and I’m working on automation of the rule violations sheets. For each violation, there is the first consequence with a date duration and a second consequence with a date duration. Example: Late for Cewfew: 1st offense no passes for 14 days. 2nd offense no passes for 30 days.

I have the duration formulas figured out, but I need to link them to another table only showing the current duration end date. I’m wanting to create a Current Offense End Date.

Basically, If the 1st consequence end date is empty then I need it to enter the 2nd consequence end date.

I hope that makes sense. I just have not been able to figure it out.

Thanks in advance for any help


Hi @Kathryn_Curtice , could you include some screenshots of the automation and the table setups?

Once I know how your data is setup I’ll be able to provide some assistance; as it is now I don’t have enough to go on I’m afraid

I figured it out thanks for your help

This topic was solved and automatically closed 15 days after the last reply. New replies are no longer allowed.