Learn how to use calculating columns. SharePoint has the ability to perform calculations, just like Excel—and just like Excel, it goes way beyond simple math!
- [Instructor] Let's talk some more about…calculated columns, okay?…Calculated columns are nice…because they do the work for you.…As I mentioned earlier in this course, the formulas…you use here are very similar to those in excel.…So, not only can you do basic mathematical calculations,…you can do some pretty complicated logical work as well.…Let's start by taking a deeper dive…into the Total Invoice Amount column.…I'm going to go into my list settings…and I'm going to scroll down to Total Invoice Amount.…
I'm going to click in here, you can see this is a…calculated field based on other columns.…So lets click down.…Now, look here.…Here is the calculation that is involved here.…I actually cheated a little bit,…I've got another column that you didn't see in the view…that calculates the Gross Invoice Amount,…The quantity ordered multiplied by the unit price.…Now, I could have done that calculation here,…but I thought it might be useful to have that as a value.…
And it did save me a little work in this column.…My calculation here takes the number from the Gross column,…
Author
Released
3/14/2018- What is metadata?
- Common SharePoint challenges
- Using metadata in SharePoint
- Calculating columns in lists
- Adjusting list permissions
- Using version control
- Creating multiple views
- Filtering view results
- Integrating with other Office apps
Skill Level Intermediate
Duration
Views
Related Courses
-
Designing a SharePoint Taxonomy
with Gary Yeoman37m 34s Intermediate -
Business Apps for SharePoint Monthly
with Gini von Courter2h 29m Intermediate -
SharePoint: Integrating with Access
with Robin Hunt2h 19m Intermediate
-
Introduction
-
Welcome1m 8s
-
-
1. Understanding Digital Information
-
What is metadata?1m 14s
-
The power of metadata3m 1s
-
2. Common SharePoint Challenges
-
3. How Can You Use Metadata for Your SharePoint Site?
-
Understanding your data3m 17s
-
-
4. Metadata in SharePoint Lists
-
Lookup columns2m 44s
-
Calculating columns3m 35s
-
5. Smarter Document Libraries
-
Restoring old versions2m 36s
-
6. Getting the Most Out of Views
-
Creating multiple views3m 21s
-
Filtering results5m 10s
-
Staging views on pages5m 19s
-
-
7. Integrating with Other Office Applications
-
Linking to Microsoft Project1m 47s
-
Conclusion
-
Next steps2m 14s
-
- 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.
CancelTake 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.
Share this video
Embed this video
Video: Calculating columns