Calculate due date based on last reviewed date

shma014543 · 06/11/19

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 · 06/12/19

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 · 06/12/19

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

Smart Sheet Form.JPG

Smart Sheet Screenshot.JPG

Andrée Starå · 06/12/19

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 · 06/12/19

To the bottom of the sheet

Andrée Starå · 06/12/19

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

Comments