Re: Help with date formulas

562 0
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

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


2 Replies 2

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

5 - Automation Enthusiast
5 - Automation Enthusiast

I figured it out thanks for your help