Auto Calcuate Due Date Formula
I am trying to calculate a due date based upon a 5, 15, 30 day criteria. The problem I am running into is that the way I have the 1st row of each area setup (it is broken down by equipment, then sub categorized into dates).
I have a formula setup to auto calculate the # of days criteria based upon "low, medium, high" priority.
I want the due date to auto calculate based upon "5, 15, 30" days from the created date, but when I do so, it throws a weird date in the due date column.
Answers
-
Hi, @Austyn Lynch - is your [Date Reported] column set up as a Date column type or a Text/Number column type? (You can tell by looking at the column preferences.)
To use date-based formulas, your target and result cells have to be formatted as date-type columns, which might explain why you're getting the odd result in your [Due Date] field.
If your columns are correctly formatted, can you please share the formula you have in the [Due Date] column?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!