How to create a Calculated Column on a SharePoint list or library

💻 NEED HELP?

________________________
🆓 FREE RESOURCES

________________________
👍 LET’S GET SOCIAL

________________________
🎧 PODCAST

________________________
💌 TIPS IN YOUR INBOX

________________________
💬 JOIN THE CONVERSATION!
Leave a comment for me below 👇

[robh]

As always, it's so easy with an expert, thank you!

[MsJsmith]

Great video. Simple and to the point. Just what I needed!

[Mahmoudalgindy]

Revisiting the Tutorial after 3 years, and still invaluable

[tontolim]

So great & useful!! Did not realise Sharepoint supports conditional formula =)

[sy_elephant]

Thanks for this succinct video! Clear and to the point!

[moisestatis]

Thanks so much. I learned something new. I did not know I can use Excel formulas in Sharepoint. That's is great.

[wynethgokul]

Great Video. Very helpful. How do I create a calculated column based on date and including only the work days. (It should auto calculate a date based on week days and company holidays)

[denblackie-superneoturbome]

Hi, I'm using a modern sharepoint site & created a new Microsoft List in there. At timestamp 1:59, you create a new column & under "Name and Type" you choose the option "Calculated". This is not an available option, I don't see this for our Sharepoint. What could cause this ? Kind regards

[erickwright]

How can we add to the formula a condition that if the reminder date falls on a weekend or holiday, to instead send the reminder on the previous workday? I understand this will likely require an added Holiday date column to reference, but am unsure of the formula needed. Great video, Thanks!

[ashvinsaini]

Hey Thank you for sharing such video. Nice Information!. I am trying the same one but it show wrong if the "Expiration Date" Column is empty. How to resolve this.

[MithunKanji]

Hi Thanks for the video. Is there a way to calculate only weekdays between 2 dates and return the number of days? I want to implement this in MS List

[abhiramsharmakoride]

Can I make the calculated column as unique column? Similar to Primary key?
I read most of the documents which says NO, but wanted to check from you for other alternative solution.

[marnellej]

Would it be possible to create a calculated column in sharepoint that would display the Job Title from another Person column? creating a sharepoint list that has employee and job title, wherein the employee column shows the person field, while the title will display the jobtitle

[fidomcvitie]

Great video. Any tips on how to calculate a date or lapsed number of days from TODAY's date? Thanks.

[MrPherez]

Quite some good insight into SharePoint, i did not catch the modified date column, is it todays date or rather what if a contract is expiring in the 14 or 7 days how do we put it in update status column ?

[kaitcho]

Thank you - how do I create a currency column? I know you can select currency BUT when I have my word template, the thousands separator doesnt show (only shows in the Sharepoint column) - I believe this is the right formula =DOLLAR([Col1], 2) BUT I'm not sure how to implement it...TIA

[detectiveconan]

An excellent Video, Thank you
I've a question : What should we do if the column that we wanna add to the Formula was not there in the Box ? actually this my problem right now . ( Note : The value's type of this not exists column is a Lookup values )

Thanks .

[RJ-cggs]

Video was really helpful! But i have a question i have a similar formula using [TODAY] but it doesn't automatically refresh the list to calculate the next day. Only way is resaving the column or modify a particular item to recalculate for current day. Is there a way to automatically refresh the list so it can calculate the column with [TODAY] formula? Thanks

[shrreyasethi]

hey if can you help me with this. i wnted to add delay column in wichh i am supposed to minus the existing the date from todays date to calculate delay.

[prabakaranmunusamy]

Hi, is there any way that we can compare today date to check an item is due or not using “Target Completion Date”. Basically if the item is passed the target date a column should show Due. In my share point I only do have Target Completion Date