Sign in to join the conversation:
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
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
When I add these I still get nex review due. = the formula I typed in. Please see screenshots
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
To the bottom of the sheet
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.
Andrée
Date Report Partner CBO Name 01/12/25 Children's org 05/15/25 Foodbank 08/30/25 Children's org 09/11/25 Chamber 11/25/25 Digital Bus 08/21/24 Digital Bus South 01/15/26 Children's org 01/12/24 Foodbank Sister 02/15/24 For the children org 07/01/26 Digital Bus #2 08/05/26 Family Center 12/01/26 Family Center I am trying to…
I am trying to get the passenger count per month per year, and I can't seem to get the formula correct. I need to add the number of passengers for each month per year. If anyone could assist me with this, I would greatly appreciate it. Thanks!
I need to edit a large sheet that has a lot of predecessors. I need to delete one row and move another. when I make the changes the predecessors for proceeding lines are not correctly displaying the dates correctly. Need help.
