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’m having an issue with the % Complete roll-up in Smartsheet. In the File Storage parent row (line 10), two out of the three child tasks are marked 100% complete, but the parent row is still showing inaccurate % instead of calculating the summary correctly. Could you help check why the parent row is not calculating…
Please see attached, formula has worked for a long time an typically pulls the data from another sheet as intended. I looked today and suddenly I have a "2" in a lot of the empty fields, and cannot figure out why. The formula I am using: =IFERROR(IFERROR(INDEX({PERFECTION YARD CHECK RO #}, MATCH(VIN@row , {PERFECTION YARD…
Hello Community, Especially you @Paul Newcome the Formula Guru! I cant resolve this problem in the last 2 columns of this sheet. As you can see the Expected Cumulative Progress % is adding the Progress Weight + the value of itself from the row above…. any idea how to make this dynamic? Whenever new row is added / removed…
