How to Create a CALCULATED COLUMN in Microsoft Lists

In this step-by-step tutorial we will learn how to create a calculated column in Microsoft Lists or Sharepoint Lists. Follow along as we demonstrate a simple calculation and also showcase how to use an IF statement in your calculated column. Additionally, we'll share some essential tips and limitations to help you get started. By the end of this video, you'll have a thorough understanding of how to create a calculated column in Lists, making it easy to organize and analyze your data. If you are a student, teacher, project manager, business owner or super nerd like me, then we have got you covered!

RECOMMENDED VIDEOS

Microsoft Lists:

OFFICE SKILLS WITH AMY

Creating easy-to-follow & fun, how-to-technology videos so that you can be efficient and save time in the workplace.

DISCOVER YOUR INNER NERD

In Wikipedia's definition of Nerd, the word has been "redefined by some as a term of pride.'

I have been advertising myself as an Excel Nerd in interviews since 2009. My goal is to inspire You to Discover Your Inner Nerd.

WHAT WILL YOU LEARN
- Be efficient
- Automate Tasks
- Save time

NEW CONTENT WEEKLY

TECHNOLOGY VIDEOS TO COME

Microsoft 365 apps including Microsoft Office, Microsoft Loop, Microsoft Teams, Microsoft Excel, Microsoft Word, Microsoft PowerPoint, Microsoft Outlook, Microsoft OneNote and more!

LIKE, COMMENT & SUBSCRIBE

If you like my videos then please give them a thumbs up and hit that subscribe button :) If you have ideas for future videos that please feel free to pop them in the comments. Let's Nerd out!

REFERENCES
Audio: Sunset Strip by Audionautix is licensed under a Creative Commons Attribution 4.0 license

Common Formulas from Microsoft

[DominicDSouza]

Thank you so much for this tutorial. I had been racking my brains to figure out what I was doing wrong! in the Microsoft forum, there is only reference to the formula but nobody says you need to go through the steps that you show here. Much appreciated!

[Naveenkumar-ppiu]

Thanks Amy, for the video. It was lucid and simple. Greetings from Hyderabad, India 🤗👍

[stephd]

Thanks- that was exactly what I was looking for!

[antonyj]

Thank you very much for the information. Is there a way to add the "creation date" column? Without it being editable... 🙏

[bizcal]

Nice Video, but I am looking for a formula to add risk score column which will be dependent on two other columns. For ex "impact" rating is "major" and "likelihood" rating is "possible" then it should give a risk score of "8"

[phloem]

thanks. How to you get a sum to show at the bottom of a calculated column? This not natively available for calculated columns.

[heribertosanchez]

Nice & Simple thanks Amy for Sharing, It really helps a lot ¡

[NabilDerouiche]

Thank you for this excellent video. Is it possible to calculate a difference between an existing date and today's date?

[Antoniopagliuca]

the calculate colum still exist?
i have free version and it is no longer available, do you know if the reason is the free?

[MrWanted]

can we display the sum the SUM of a calculated column? for ex: the cost column in the video

[vlrfdqc]

Is there a formula for taking out weekends and holidays?

[samuelshehata]

Hi, I wonder if we can use the Today's function to create a review date conditional formatting on MS Lists
Example: Conditional format policies based on review date.
For Review Within 6 Months
For Review Within 1 Year
For Review Within 2 Years
For Review Within 3 or more Years. Thank you.

[libafriedlander]

Can a formula be added to have the date column change colors based on current date plus one week?

[brandonrodrigues]

Is there a way to concatenate 2 columns into calculated field and check for uniqueness and non blank ?

[AbdulJabbar-gdxe]

Which office platform is this. Is this excel or PowerPoint

[JuanSalvoElEternauta]

Hello Amy! Thanks for sharing these tips!
BTW, I have a list with two Choice columns I'd like to link (if possible). I want the 2nd column to show a set of values for selection when you choose a value in the first one. Can this be done? Thanks again! You got yourself a new subscriber :)