Learn to add calculations in lists. Learn to calculate the number of days between two dates. Learn how to write an If function with dates in your list.
- [Instructor] It's easy to calculate…information in SharePoint.…Let's go add some date calculations to our issues list.…So to expand on our analytics, we want to know how long…an item is estimated to be open,…and actually how long it was really open.…So we need to add a closed date field here,…and then we can do some additional calculations.…Let's go to our list tab, let's go to list settings,…okay, we're going to scroll down, we're going to create a column,…we're going to name this date closed,…and we'll do a date time field.…
Date the issue was closed is our description,…and it doesn't need to require information,…because they're open until they're closed.…We're not worried about unique values here,…and the date only time format is fine.…We do want to add it to the default view.…We can just go ahead and click okay.…So we actually want to be able to calculate…between the opened date and the due date,…and the difference in days that elapse between the two,…so we're going to start there.…
In your exercise files, there's a Calc Notepad…
- Building an Access table and a SharePoint list
- Linking a SharePoint list to Access
- Exporting a table to SharePoint
- Connecting SharePoint to Access
- Creating macros to open lists
- Modifying Access forms
- Working with views
- Building reports for your integration
- Building views for data in SharePoint
- Sharing a SharePoint site with permissions
Skill Level Intermediate
SharePoint 2016: Branding SharePoint Siteswith Gini von Courter56m 10s Intermediate
SharePoint 2016: No-Code Workflowswith Gini von Courter1h 19m Intermediate
Access 2016: Reporting to Web Systemswith Adam Wilbert1h 47m Intermediate
1. Aligning Data between SharePoint and Access
2. Connecting SharePoint to Access
3. Building Forms for Your Integration
4. Building Reports for Your Integration
5. Building Views for Data in SharePoint
6. Generating Excel Reports for SharePoint
Linking data to Excel2m 26s
7. Finalizing the Database for Production
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.