Questions tagged [calculated-column]

Calculated columns are the SharePoint equivalent of Excel formulas. They allow you to display values that are calculated from the values of one or more other columns. These calculations can be made using standard mathematical operators and SharePoint's built-in functions.

Filter by
Sorted by
Tagged with
0
votes
1answer
18 views

SharePoint list column IF statement

I have run out of IF multiple statement within SharePoint list calculated column, I still have more sites to add. I'm looking into a different way to build IF statement to fit all my sites (30 in ...
1
vote
1answer
31 views

Calculated column formula help

I have a request to generate a tracker number when a new item is created to a list based on the below logic: The number format is "TN" + CurrentDate(ddMonYY format) + Counter. eg: ...
0
votes
1answer
2 views

Version revert causing inaccurate information to be retrieved during first flow run subsequent to the revert

I am not sure if this is a legitimate question since I am more like reporting what I think is a legitimate issue, but I recently seem to be seeing that reverting to a version of a flow will prompt it ...
0
votes
2answers
28 views

SP list Calculated column

Trying to do calculated column where if the column text length is equal to 176 characters column returns 1, if not 0. Using this formula: =LEN([AZDP]=176, "1", "0") This is ...
1
vote
2answers
34 views

SharePoint Online List - days between two date columns

I've got a very simple formula to calculate the number of days between two dates which works, with one exception. Formula: =IF(ISBLANK([Completed Date]),"TBC",[Completed Date]-[Created Date])...
0
votes
1answer
11 views

SP list calculated field

Trying to make SP List calculated field for three sites. Each site has two conditions. Using statement: IF(AND([Site_induction]= "Chester TCC" , [Speed_limit]= "5mph"), "1&...
0
votes
1answer
17 views

Calculated line- I want Yes /No based column

I want a Calculated Column in SharePoint 2013 that is based on Yes/No from another Column. So I have a Column with Yes/No called "Error". I have another column that say "Error Id" ...
1
vote
1answer
21 views

ID column does not work with concatenate formula in SharePoint list

I am trying to create simple unique ID for my SharePoint List. All I need to say is ABC-001, ABC-002 ETC. I am using formula =concatenate("ABC-", ID). It works if I refresh the formula every ...
0
votes
1answer
23 views

Automatically display an image according to a category

I have a document list with 2 columns. the first column is a category (Example: Menu, General, Information) The second is an image. I would like the image to be automatically calculated according to ...
0
votes
1answer
15 views

Cannot Filter List View with Yes/No Values

I am trying to create two different views for work anniversary and birthdays to only show if the current month is the same as hire date and birth date. I have the following calculated column, which ...
0
votes
1answer
30 views

Looking to trim leading and lagging spaces from Title column in a Sharepoint list

So I'm trying to integrate Power Automate into our SharePoint workflow to create a folder with the same value as the value inputted into the Title column of our SharePoint list. The flow failed today ...
0
votes
1answer
18 views

Calculate the difference between current day and date column in years

I have a column StartDate and I want to calculate the time difference in years from that date to the current day. For example: My start date of work is 4/19/2016, it will be 5 years until 4/19/2022 ...
0
votes
2answers
29 views

Calculated column difference between two dates considering Today

I have a calculated column to determine the number of days between Introduction call date and Today's date. It works fine as long as the introduction call date is less or equal to Today's date but ...
1
vote
1answer
7 views

Can I overload a URL to return multiple subfolders in a calculated column?

I have two images that are both located in my site assets folder and I want to show the two images based on when a source column returns "yes" or "no". I have a wrapped around a ...
0
votes
1answer
13 views

SharePoint 2019: One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas

I keep getting this error message One or more column references are not allowed, because the columns are defined as a data type that is not supported in formulas but I don't exactly understand what ...
0
votes
1answer
6 views

How can I use a SharePoint lookup value in a Calculated field?

I have a list that has 1 field that is a lookup and another which is a calculated field that I wanted to concatenate the lookup value with another field. I worked out the answer below. regards Michael
0
votes
1answer
24 views

What is the maximum syntax formulas that I can use in calculated column on my Sharepoint list?

I have created 20 syntax formulas (IF(AND([Job Group]=) based upon two other columns on my calculated column field, but I seemed to have reached a maximum limit. I cannot load my 21st syntax formula ...
0
votes
1answer
16 views

If Statment ( [DateTime in a Sharepoint Column] = Now (), Yes,No )

Curious to know if this is possible, i wish to create an if statment in a sharepoint calculated column where if the date in that row is equal to the time now than mark the column as yes. The datetime ...
1
vote
1answer
49 views

Calculated Column based on the other column which is of type choice in SharePoint list

I am very new to the whole SharePoint and excel formulas and I am in the process of learning. I have a list in SharePoint in which I have multiple columns. I want to create a calculated column based ...
1
vote
1answer
86 views

Calculated Column Based off of a Date & Time Field

I have a field called "Onboarding Date" which is a Date & Time field. I want to create a new field called "RetentionDate" which will be a date 1 year later than the users input ...
0
votes
1answer
40 views

Need to count number of days until value of another column is set to a specific value. [Days Open] counts until [Status] = Complete

I have a [Date Reported] column and a [Status] column. I want to count the [Days Open] value until the selection in the [Status] column is set to "Complete". Once set to "Complete",...
0
votes
1answer
18 views

DATEDIF function returning wrong number of days

I am not able to get the number of days between start and end dates. I am using DATEDIF(Start_date,End_date,"D") which seems correct as per articles https://support.office.com/en-US/client/...
1
vote
1answer
48 views

SharePoint calculated column based on other 2 columns

I am struggling writing the formula for SharePoint calculated column. I have 3 SharePoint Columns: [Vaccination date]; [Infected] - Yes/No choice; [No testing is not needed (date)] In column [No ...
1
vote
1answer
17 views

Help with If/And

Running SP19 On Prem. Have a list with a column looking at type category with three options, and a completed column. I am looking at a calculated field/column in the list to filter a view with. 1st ...
0
votes
1answer
23 views

SharePoint list calculated column formula

Is it possible to make a SharePoint list calculated column so that if value equals to Italy it returns '1', otherwise '0'. I am using: =IF([Question 1]= "Italy" , "1", "0"...
1
vote
2answers
32 views

Multiple IFs and ORs

I'm new to SharePoint lists and prefer not to work with them, but my employer has decided to utilize it. The process/formula I have in excel works, but not in SharePoint lists. We need a Calculated ...
1
vote
1answer
26 views

IF statements SharePoint 2003

I am using SharePoint 2003. Only 7 If statements on SharePoint: 1,2,3 < green 4,5,6 yellow 8,9,10 amber 15 > red =IF(RAG<=3,"Green",IF(RAG=4,"Yellow",IF(RAG=5,"...
0
votes
2answers
28 views

Not able to use renamed Title column in a calculated field

I'm trying to set a formula that uses the Title field which was renamed. But when I save the calculated field the SPO shows an error telling me that I'm using a field that does not exist (!!!). The [...
0
votes
1answer
48 views

Calculate Days, Hours and minutes between two different dates and times

I have a SharePoint list with two date columns. I want to create calculated column which gives the number of days, hours and minutes between these two dates. I have looked at all possible threads, but ...
0
votes
1answer
24 views

SharePoint 2013 Calculated column issue -Comparing dates

Hope you can help me on this issue. I created a calculated column with the following formula to auto calculate the "Fiscal Quarter" based on the value in the "Date Of Review" ...
1
vote
1answer
37 views

Check if a time is between two other times including minutes

I have a PowerApps form which contains an adjustable "Submission Date" field. Here is a screenshot to show what I mean: I am trying to come up with a formula for a calculated column in ...
0
votes
2answers
24 views

Additional option in Column Validation

I have a a validation that only accepts a specific format of 6numbers followed by a dash and further 6 numbers as below: =IF(ISBLANK(FAQ),TRUE,AND(LEN(FAQ)=13,MID(FAQ,7,1)="-",ISNUMBER(MID(...
0
votes
1answer
22 views

Calculate business days between start date and end date

BLUF: I would like to create a calculated column in SharePoint that looks at the [Start Date] and [Provisioned Date] and know how many business days it took between the two. I am very new to ...
1
vote
1answer
24 views

SharePoint Online Calculated Formula

I am trying to create a formula that will auto-populate a column based on the input from two other columns. The auto population would need to check the boxes of the appropriate items that apply based ...
1
vote
1answer
30 views

Calculated Column Formula not Working

I'm trying to create a calculated field with the following formula, but when I try to save the column with this formula it returns a syntax error. What's wrong with the formula? Formula: =CONCATENATE(...
0
votes
1answer
21 views

I am using an IF function for a column but its giving me an error and I am not sure what the problem is. Can someone please help?

My formula: =IF(AND([Column 1]="Low",[Column 2]="Low"), "No", IF(AND([Column 1]="Low",[Column 2]="Medium"),"No", IF(AND([Column 1]="...
1
vote
2answers
128 views

Sharepoint List 2016 - Replace text

How can I replace the space in between a file name in a calculated column in SharePoint list 2016? Example I have a file name that contains ABC 123 and I want a calculated column to return the value ...
0
votes
1answer
25 views

Calculated Column Assistance Needed

I have an expiration date column, and I need to mark the date red yellow green depending on: if the exp date is within 30 days from today = red if the exp date is within 60 to 90 from today = yellow ...
1
vote
2answers
27 views

Multiple IF statement in one calculated column

I have tried everything, can someone help me with this? =IF(ISBLANK([Date1]),DATEDIF([Created],[Date2],"d"),IF(NOT(ISBLANK([Date1),DATEDIF([Date1],[Date2],"d")))) It keeps saying ...
0
votes
1answer
35 views

Please Help with Calculated Column

Here is what I'm trying to do: I have 3 columns, that if they all have certain values, I increase the value of calculated column by 1. So if the value of the calculated column =3, then I want the ...
1
vote
2answers
74 views

IF Statement in a SP Library Calculated Column

I have an SP Library that has a 'Name' column. The names of the documents are formatted as follows: 2021 CT0000 Driver Charlie Tuna 1_1_2021.jpg 2021 CT0000 Driver Capatain ...
1
vote
1answer
52 views

How to include calculated column in "New item" in Sharepoint list?

I have 2 calculated columns Urgency and Priority which I need to show in New item in SharePoint which will help the users in knowing/understanding them before they submit the request. Also is there ...
1
vote
1answer
33 views

Working with the file name

I am fairly new to SharePoint and also working with a German version, so please excuse and correct any wrong terminology. On SP2016, I have an image library and have added a calculated column. I am ...
1
vote
1answer
37 views

Multiple conditions in in Sharepoint calculated column

I am a bit new to SharePoint lists. I am trying to create a calculated column with multiple conditions as below. So the priority needs to be automatically calculated based on other 2 columns Impact ...
1
vote
1answer
21 views

Calculated column from period

My sheet contais 3 columns - date, time period (choices: one yer period, two years period and half year period) and I would like to create rule for the third column which suppose to calculate the ...
1
vote
1answer
40 views

SharePoint calculated column using AND

I'm wanting to create a column that will provide a yes or no answer depending on some other conditions. I thought I found something that was going to work but it didn't. So basically Annual pack days ...
1
vote
1answer
49 views

Using date commands in calculated fields

I am following this article: Examples of common formulas in lists A simple sample is this: =DATEDIF([Dato1],[Dato2],"d") However when I save the column I get following error: Sorry, ...
1
vote
1answer
26 views

SharePoint Calculated Column showing #NUM!. One of the Column needs to be in Completed Status

I have a calculated column that will get the date difference between the two columns. Conditions: Difference between Completed Date and Created Date. Weekend should not be counted. If Completed Date ...
0
votes
1answer
20 views

Sharepoint 365 Document Library Calculated Column Searching for Text

I am trying to search in the files names for HC, so I can have a Yes / No output to be able to filter on it, since MS does not have a does not contain option in filter. Names of the File: SLS802 2021 ...
0
votes
1answer
11 views

How to incorporate sorting in calculated column with background and text color formatting to use as a Grouping field

Here is the calculated formula for the field: =IF([AU-R CIR]="7. ERROR","<div style="""&"text-align:center; color: red; background: #ffffff"&"&...

1
2 3 4 5
23