Archived 2016 Posts
Archived 2016 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Calculating date due for Service Level Agreement
Kevin Jordan
✭✭
I have a date assigned column which would be the date someone entered a case. I'd like to automatically calculate in a due date column the 5 day SLA date, accounting for weekend days. Is there an easy formula for this?
Tags:
Comments
-
Kevin,
do you mean the due date is 5 days later than the date of entry? If so, the formula is =EntryDate1+5 (for 1st row)
If the EntryDate is a system-generated date like Modified(Date) or Created(Date), then you need to put it this way:
=DATEONLY(EntryDate1)+5
I hope it's what you meant
Atus
This discussion has been closed.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.5K Get Help
- 468 Global Discussions
- 156 Industry Talk
- 511 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 521 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending Posts
- Not sure when this changed, but it was recent. I used to be able to create folders for organization within my Sheets directory. Now there is no option to do so. The menu options are gone. If I create …
- Hi there! I'm working on an inventory of documents. The formula I want is one that would enable me to determine the last time a resource was updated. It'll use a checkbox column. Below is a list of wh…
- I have a dashboard that is using a Metrics Widget to display summary data. I want users to only see the summary data for their region. What is the best solution to achieve this? Is Dynamic View a solu…
