Calculate due date based on last reviewed date
Comments
-
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
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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.
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!