Calculate due date based on last reviewed date

shma014543

The policy was reviewed on June 1, 2019, I want the next due date to be in 365F  both columns are date fields

Formulas I tried- 

=[Column4] + [365]

= Reviewed Date + 365

fx=Reviewed Date + 362

sean59916

Hi - 

You need to add the row reference to the formula, i.e.

= [Column4]1 + 365

or

= [Column4]@row+ 365

I hope this helps you out?

Regards, 

Sean

shma014543

When I add these I still get nex review due. = the formula I typed in. Please see screenshots

Andrée Starå

Hi,

It's because you can't add formulas to the forms. You'd have to add the formulas on the sheet.

Do you want to add the new submission in the top or the bottom of the sheet?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

shma014543

To the bottom of the sheet

Andrée Starå

Ok. 

If at least two rows have the same formulas and pattern it would add automatically to the new rows as long as they are on the same level. 

I have a trick I use when I add the rows on top. 

Best,

Andrée