If Formula
Hi I'm trying to auto calculate the date. I was wondering if someone could assist. I'm not quite sure how to do it I believe it should be an if statement but I'm not sure how to write it.
I have a column that is Date of Last Correspondence, Days till follow-up, Next Follow up Date is the column that I want to auto populate.
Days till next correspondence is 7 Days, 15 Days, 30 Days, 45 Day, 60 Days, 90 Days, 120 Days, 365 Days. If Custom Number is selected I want the column to be blank.
I'm not sure how to write the formula. Any assistance would be great
For the test row I just put ==[Date of Last Correspondence]1 + 7 but I would like that to happen automatically.
Thank you
Comments
-
Try something like this...
=IF(ISBLANK([Custom Days]@row), [Date of Last Correspondence]@row + VALUE(LEFT([Days till follow up]@row, FIND(" ", [Days till follow up]@row) - 1)))
.
What this does is:
If the Custom Days column for that row is blank, then pull the leftmost characters from the Days till follow up column up until the space, convert it to a numerical value, then add it to the Date of Last Correspondence.
This will also allow you to add, edit, or delete options from the Days till follow up column without having to adjust the formula.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!