Questions tagged [calculated-column-formula]

Question related to the Calculated Column

39
votes
7answers
91k views

How to use Today and Me in Calculated column

I want to use a combination of Today and Me in SharePoint 2013. I am trying it in Office 365 it gives me the below error Calculated columns cannot contain volatile functions like Today and Me. Can ...
0
votes
1answer
976 views

Calculated formulas for tracking progress

I would like to let my team know if their document is progressing on track. I have a start date and due date and a column that they must enter their progress %. In a tracking column I would like to ...
4
votes
3answers
8k views

Calculated Column Formula how to replace Substitute

I need to grab everything after the last "-" (strings can have up to four "-") and if there is a space after the last "-" to not take the space. Examples: TEXT -(THIS VALUE) TEXT - TEXT -(SPACE)(...
1
vote
3answers
2k views

Count not updating in calculated column

I am getting number of days between Created & Now in SharePoint 2010 list using calculated column by below mentioned formula. =IF(ISERROR(DATEDIF(NOW(),Created,"d")),DATEDIF(Created,NOW(),"d")) ...
3
votes
6answers
24k views

Days since list item was created

I have a list. When an item is created it is automatically assigned the created date. I would like to add a “days open” column. "Days open" being the number of days from the created date to today’s ...
2
votes
1answer
2k views

Adding the digit “0” to a number in a list field

I have a custom with a field requiring to put an 8 digits number in it. In some cases when the number starts with a "0" SharePoint ommits the first "0" and display only the rest, so, a number with ...
1
vote
1answer
142 views

Perform a calculation based on other criteria

sorry in advance supernoob here failing hard and need help. I'm trying to create a timesheet in sharepoint that will eventually be a powerapp then go into PowerBI and I'm struggling bad with the ...
13
votes
1answer
775 views

Save Calculated Column Formula in Language Localized notation using REST or JSOM?

[multiple blogs/posts out there noted the issue, no solution was ever published] What is required to save a Localized Calculated Column Formula using JSOM/REST? I am injecting the script below into ...
1
vote
1answer
9k views

How can I use data from Managed Metadata Columns in Workflows and Calculated Fields?

It seems that sharepoint does not allow MM columns to be used in calculated fields, and I'm not sure how to use them in a workflow either. Can someone please inform me as to how I can use terms in the ...
3
votes
1answer
11k views

Count number of rows in another list

I have two lists, A and B. I wish to find out the number of rows in list B that have a certain value in list A (through a lookup column) and display this in list A. Is this possible at all using a ...
4
votes
3answers
1k views

Calculated column - calculate percentage done based on status

I'm trying to create a calculated column based on a status column. If the status is "planned", I'd like it to return 5%, if it is "writing", it should be 30%, if "technical review" it should be 50%, ...
3
votes
1answer
4k views

Sum Calculated Column (SP 2013)

There is a very nice solution below from ViewMaster (http://www.viewmaster365.com/#/Create/Sum) that involves some scripting within the formula of a calculated column itself. However, the Sum will be ...
2
votes
1answer
617 views

JavaScript Code in the SharePoint 2013 calculated column

I added the code below to a SharePoint calculated column in order to get today's date, and it works well, however, I will need to add another calculated column to get the date difference between "...
2
votes
4answers
4k views

How to update calculated column on a daily basis without admin rights?

I am running SharePoint 2013 and have a column that is supposed to determine whether or not each phase of a project is late. I am using the NOW() fucntion, which, of course, does not update ...
1
vote
2answers
2k views

Calculated column with link - remove space / whitespace / slash

=IF(Title<>"";"<a href='/test/"&SUBSTITUTE([Title]," ","")&SUBSTITUTE([Title],"/","")>Info</a>";"#") I'm trying to create a link based on two coloums. Is there a way to ...
1
vote
3answers
39 views

How do I make a calculated field with a filter in SharePoint 2010?

What is wrong with the formula I used: =if([van]>=[today];"[Title]";"") Where, [van] is a date/time field in a calendar. [Title] is a single line of text. Any help will be appreciated.
1
vote
2answers
418 views

SharePoint Calculated Field (DATEIF)

I'm using SharePoint 2010. Right now I have a calculated column which displays in days the difference between ColumnDate1 and ColumnDate2 as follows: =DATEDIF([ColumnDate1],[ColumnDate2],"d") But ...
1
vote
1answer
12k views

Calculated Field with formula DATEDIF

Im working with a calculated field and using a formula to retrieve the difference of the days between two dates, DATE1 and DATE2, my simple formula is: =DATEDIF([DATE1], [DATE2],"d") It works fine ...
1
vote
2answers
844 views

Get string out of url in calculated column

I have column in sharepoint 2010 list which has value like http://mysitecollection/sites/SPDev/Arizona/Lighthouse.jpg I want the value in calculated column should be Arizona. Can anyone let me know ...
1
vote
1answer
44 views

SharePoint Filters and Custom Views Total Calculations

I have a Date column where users can enter any date they want, I also have separate column that shows the month of that same date column. I am trying to create a filter that will count how many ...
1
vote
1answer
272 views

Help with SharePoint Calculated Field Multiple Values

I have the following formula on a calculated field that searches the value funnel status for values, then sets as live or active. Rather than search does the field contain a specific value, I would ...
1
vote
2answers
364 views

Extract data from meta data field and copy to new field

I have a managed term set which provides date meta data for a column used by accounts. They tag a document depending on the period (month and year) it relates to. What I wish to achieve is to have a ...
0
votes
1answer
3k views

Calculated Column Extracting Date Only in Date and Time Column Type

Intent: To create a calculated column that shows the date ONLY from date and time column type. I created a formula, but it is wrong and not sure where I am going wrong. Can anyone help? Note: I ...
0
votes
2answers
141 views

SharePoint calculated column based on value of another field

I'm trying to do some automated scoring based on the values of various Choice fields: Column name is Project Choice values are Widgets1, Widgets2 and Widgets3 The scoring is based on the choice of ...
0
votes
2answers
21k views

Validating dates in SharePoint so they cannot choose a date before today's date, how would I write that formula? [duplicate]

I am back at this form I have people fill out in SharePoint Designer and have a new small issue, here is my formula: =AND([Requested Posting Date]>=[Date of Request]+1,IF([Date of Request]="New",[...
0
votes
3answers
6k views

Formula to show differens between dates without weekends and holidays

If anyone know formula without code in SharePoint 2010 to show differens between dates without weekends and holidays, I'm trying to find solution but no result so far ... I will be veru gratefull for ...
0
votes
2answers
59 views

Calculated Column Formula to hide blank values

So this is a follow up from my question yesterday as I believe I have found a work around or at least a potential one. To cut a long story short I have a list called "Team Information" this contains ...
0
votes
1answer
135 views

How to add an image in a calculated list column

I want to use and image instead of a text in a field. see this image The edit column its a calculated column. If users click on it. It will opens the editform.aspx. So i want to use an image instead ...