How to automate date population between cells?
I am looking to store items within my inventory system. I have a column "storage date" that I populate when adding the item to the shelf. I also would like my retention date in the "keep until" column to auto populate adding a year to the "storage date" listed in that cell on the same row. Is there a way to automate this action or do I need to rely on a formula?
Answers
-
Hi @Jtbeck
I would probably use the following formula,
if(isblank([storage date]@row),"",[storage date]@row+365
and convert to a column formula, that way it is always there doing the job but not populating any rows that havent been added to as yet.
Hope that helps
Paul McGuinness
Central Operations Manager at Care UKIf you found this comment useful, please let me know by clicking one of the buttons below: Awesome, Insightful, Upvote, or Accepted Answer. Your feedback will assist others looking for the same information and also help me out.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.2K Get Help
- 445 Global Discussions
- 143 Industry Talk
- 476 Announcements
- 5K Ideas & Feature Requests
- 85 Brandfolder
- 150 Just for fun
- 71 Community Job Board
- 488 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 301 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!