💻 Want to confidently navigate SharePoint and Microsoft 365? Enroll in my revamped On-Demand SharePoint and Microsoft 365 Academy 👉 academy.sharepointmaven.com/
Hi great vid, i have a question, if i created a choice list and wanted to add a score/point system to that and add it all up after can i use the calculated column to achieve this
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
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.
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 ?
Hi, great video. I have 2 columns and a total column. The total is calculating columns 1 and 2 but I'd like get an average of the total column. but it seems calculated columns don't have the option to do this (it works on columns 1 & 2 when I use the standard option) is there a way I can get an average if the total column? Thanks
You have to talk to an Excel expert about this. Yes, It is possible. Suggest you check out this: www.amazon.com/SharePoint-Calculated-Columns-Validation-Formulas/dp/098289922X
Hi Maven, SharePoint serial number why not sequenced, for example, S # must be 1,2,3 instead of 1,10, 100, 11, 12 13, please let me know how to do that in SP
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.
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 .
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
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.
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!
Hi Erick, I am not an expert on Excel formulas, I am sure this is possible, highly recommend this book that might contain the answer: www.amazon.com/SharePoint-Calculated-Columns-Validation-Formulas/dp/098289922X/ref=sr_1_1?dchild=1&keywords=SharePoint+Calculated+Columns+and+Validation+Formulas%3A&qid=1626874452&sr=8-1
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
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
Hi Maven, is it possible to create a new column using the First column for e.g. in your video it’s the “Name” column. Can we create a new calculated column that can use the “Name” column as Prefix. Thanks
Hello, I saw that you have a column "Name" with PDF and that's exactly what I have. For deleguation issue in power apps, I need to created a meta data column only with pdf name. So I tried a calculted column with the formula " [Name]" or "[Title]" but noting work, is it possible to do it ? thanks
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)
Mike Smith has the formula in his book: www.amazon.com/SharePoint-Calculated-Columns-Validation-Formulas/dp/098289922X/ref=sr_1_2?crid=10G8FXLYEIQH6&dchild=1&keywords=sharepoint+calculated+columns&qid=1628814993&sprefix=calculated+column+%2Caps%2C172&sr=8-2
Thank you. I would not know right away, but I suggest you reference this post for ideas: techtrainingnotes.blogspot.com/2018/10/sharepoint-calculated-columns-and.html
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
My research tells me updates only happen when something is added or modified, but using power automate there is a way. Hope I can figure out later, but looks like you would remove your calculated columns from SPO list, then have the automation do the calculations for you. This would keep the list refreshed.
Do you know how to count values across a row? I just want to count how many times a word appears and have this number in the last column but the lack of COUNTIF is annoying! Can you combine COUNTA and IF in anyway? Please help! I'm pulling my hair out!!
💻 Want to confidently navigate SharePoint and Microsoft 365? Enroll in my revamped On-Demand SharePoint and Microsoft 365 Academy 👉 academy.sharepointmaven.com/
Revisiting the Tutorial after 3 years, and still invaluable
Thank you!
As always, it's so easy with an expert, thank you!
🙏 Thank you! Appreciate the feedback! And thanks for being my loyal follower
Thanks so much. I learned something new. I did not know I can use Excel formulas in Sharepoint. That's is great.
You are welcome!
Very Helpful Thank You👏👊
You are welcome!
So great & useful!! Did not realise Sharepoint supports conditional formula =)
Yes, it does!
Thanks for this succinct video! Clear and to the point!
You are welcome, thanks for being my loyal follower
Thank you for a great video.👍
My pleasure!
thank you so much!
You're welcome!
Great video. Simple and to the point. Just what I needed!
Thank you, Jacqueline! Appreciate the feedback!
Hi great vid, i have a question, if i created a choice list and wanted to add a score/point system to that and add it all up after can i use the calculated column to achieve this
I suggest you google for ideas, there has to be a formula that works
@@SharePointMaven yeh have been...really hard...
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
I cannot tell you why it is not there. Suggest you reach out to Microsoft on this
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.
You need to create a formula to ignore empty cells
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 ?
Ferez, Modified Column is the last modified date of a document. If I understand your question correctly.
Hi, great video. I have 2 columns and a total column. The total is calculating columns 1 and 2 but I'd like get an average of the total column. but it seems calculated columns don't have the option to do this (it works on columns 1 & 2 when I use the standard option) is there a way I can get an average if the total column? Thanks
I doubt this. Can't do calculated column on a calculated column
@@SharePointMaven thank you, good to know one way or the other, guess I'll need to rethink this.
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
You have to talk to an Excel expert about this. Yes, It is possible. Suggest you check out this: www.amazon.com/SharePoint-Calculated-Columns-Validation-Formulas/dp/098289922X
hello, do you know how to generate a custom ID automatically when I add a new item into the list?
No, I do not
@@SharePointMaven thank you！
Hi Maven, SharePoint serial number why not sequenced, for example, S # must be 1,2,3 instead of 1,10, 100, 11, 12 13, please let me know how to do that in SP
I have no idea
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.
You should use Power Automate for this
@@SharePointMaven how do we do that?
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 .
This means those types are not supported and can't be used. This column type has limitaitons
@@SharePointMaven Oh, so I can't use this column even if I try to write it's name in the correct way ?
@@detectiveconan484 I doubt it
Tks, you helped me a lot. TKSSSS
You are welcome!
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
Probably, but this is outside of my expertise
Power Automate can calculate that using a condition (If, then, else). Not sure if that's an option for you to explore further
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.
I am not aware of a way to do this either
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!
Hi Erick, I am not an expert on Excel formulas, I am sure this is possible, highly recommend this book that might contain the answer: www.amazon.com/SharePoint-Calculated-Columns-Validation-Formulas/dp/098289922X/ref=sr_1_1?dchild=1&keywords=SharePoint+Calculated+Columns+and+Validation+Formulas%3A&qid=1626874452&sr=8-1
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
Not aware of an OOTB way to do this
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
I would not know the answer to this - never encountered this scneario
Hi Maven, is it possible to create a new column using the First column for e.g. in your video it’s the “Name” column. Can we create a new calculated column that can use the “Name” column as Prefix. Thanks
I don't think so, not 100% sure
@@SharePointMaven Thank you Maven for taking the time to reply. Appreciate it Sir.
Can be done with Power Automate using string variable...? Not sure if that's an option for you to explore further
@@TheSourceresss I really appreciate your response. Will test it out and let you know. Thank you
Hello, I saw that you have a column "Name" with PDF and that's exactly what I have. For deleguation issue in power apps, I need to created a meta data column only with pdf name. So I tried a calculted column with the formula " [Name]" or "[Title]" but noting work, is it possible to do it ? thanks
I don't think this works.
Hello. I’m getting an error message that says The attempted operation is prohibited because it exceeds the list view threshold
That means you exceeded the famous 5K view item limit: sharepointmaven.com/how-to-overcome-sharepoint-5000-item-limit-threshold/
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)
Mike Smith has the formula in his book: www.amazon.com/SharePoint-Calculated-Columns-Validation-Formulas/dp/098289922X/ref=sr_1_2?crid=10G8FXLYEIQH6&dchild=1&keywords=sharepoint+calculated+columns&qid=1628814993&sprefix=calculated+column+%2Caps%2C172&sr=8-2
Great video. Any tips on how to calculate a date or lapsed number of days from TODAY's date? Thanks.
Thank you. I would not know right away, but I suggest you reference this post for ideas: techtrainingnotes.blogspot.com/2018/10/sharepoint-calculated-columns-and.html
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
I believe this is a known fact - how it is by design
My research tells me updates only happen when something is added or modified, but using power automate there is a way. Hope I can figure out later, but looks like you would remove your calculated columns from SPO list, then have the automation do the calculations for you. This would keep the list refreshed.
Sir can you say the formula to convert litre into kg in SharePoint?? Please
I don't know
When I go to the Column Settings, the 'calculated' is not an option. What could it be?
It is only available in classic mode
Do you know how to count values across a row? I just want to count how many times a word appears and have this number in the last column but the lack of COUNTIF is annoying! Can you combine COUNTA and IF in anyway? Please help! I'm pulling my hair out!!
Just add a total column: sharepointmaven.com/how-to-do-simple-math-calculations-using-the-totals-feature-on-sharepoint-lists-and-libraries/
Trying to do this in MS Teams List App didn’t have MORE. Opening In Sharepoint worked though.
OK great
Why can't I get a Totals number at the bottom of a Calculated Column? Is that feature hidden?
Probably by design
Hello, how to show string text from three diferente columns?
I don't know
is it possible to make a calculated column to get the link of a file in string?
Not aware of a way to do this. Perhaps some Excel experts would know
Power Automate can do this.
I have a choice list. If the choice is correct, I want to calculate. eg =If( [blabla]="True";"2*2";""). But I can't do this. how can I do this?
I suggest you check this blog: techtrainingnotes.blogspot.com/ Mike has lots of examples and formulas for calc column
But how do I get a Totals number at the bottom of a Calculated Column?
Probably not possible
How to calculate average between two columns in MS List ?
By using formulas in the column
thank u
You are welcome