Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
41
votes
7answers
110k 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
1k 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
10k 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 ...
1
vote
3answers
3k 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
33k 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
37 views

Formula for swapping the choice in a drop down with a numerical value

I've got a SP drop down column which contains options like: Doesn't align to current priorities Somewhat aligns to current priorities Aligns strongly with current priorities I want to assign all of ...
1
vote
1answer
234 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 ...
0
votes
1answer
63 views

IF statement with text field isn't possible?

Trying to do formula =IF([FIELD1]=[FIELD2],1). When I try to save the formula it gives me syntax error. Is it possible to achieve this with text? The reason behind that is if texts match it would ...
13
votes
1answer
887 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
0answers
12k 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 ...
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
788 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
1answer
18k 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 ...
2
votes
4answers
6k 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
1answer
424 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
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
130 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
1k 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
46 views

Replace More Than One Comma Formula

I am trying to replace more than one comma from a single line of text field with an underscore, or some other symbol, but I want to replace it if a certain criteria is met - if the value in the field ...
1
vote
2answers
819 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 ...
1
vote
2answers
997 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
53 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 ...
0
votes
2answers
5k views

SharePoint 2013 calculated column adding multiple if statement

i created a calculated column(column name"status") with a simple formula below: =if([Priority]="Low"), "Yellow", if([Priority]="Normal"),"Green", if([Priority]="High", ”Red"))) As you can see, what ...
0
votes
2answers
103 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
38 views

Calculate number of days from date to today [duplicate]

I have tried and looked for the answer to calculate the number of days from a date to today's date and getting an error. Calculated columns cannot contain volatile functions like Today and Me. ...
0
votes
1answer
5k 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
1answer
219 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 ...
0
votes
3answers
7k 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
28k 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
2answers
624 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 ...