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
I want to assign project numbers to the main project, and then append that project number with .(letter) for the Subprojects, with Tasks still being assigned to the main project number, with the letter of the Subproject, and adding more hierarchy, such as I'd like the task to read 40.c.1, or something similar that…
Hi all! Happy Thursday. I have a formula that I created that is looking to calculate a number of cells that meet the specified criteria on a particular cell that inputs a date when a box is checked through an automation. What I am noticing however is that the formula is calculating items that are earlier than the specified…
Hi - We have a formula in a sheet =IF(Status@row = "Closed", TODAY(), "") That when the status at the row changes to closed, it was to add todays date in the Date Closed Column. However, it seems that it is now changing the date for anything previously closed to the current date. We need it to change it to the date when…
