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
0 answers
13 views

Calculate difference between dates and roundup

In SharePoint, I am trying to calculate days between two dates. My calculated formula is: =DateClosed-Created This works, but how can I change this to have the following result: If the outcome in ...
user avatar
0 votes
1 answer
14 views

How can I include the the original Item ID# in a new Item created/cloned using Power Automate flow?

I am using Power Automate to clone original Items in an existing SharePoint List. All is working perfectly, as the clone flow results in an exact copy of the original List Item. Now my users want to ...
user avatar
1 vote
1 answer
20 views

Calculated Column IF OR AND 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: = IF( OR( ...
user avatar
1 vote
0 answers
13 views

Calculated column dates are a day out when queried in Flow?

I've got a SharePoint list that is used to work out renewal dates of software. The three key columns are "NCE SKU", "NCE Purchase Date" and "NCE Renewal Date". The &...
user avatar
0 votes
1 answer
13 views

Trying to use WEEKDAY function to make a column always return a Friday date, based off another date column

So far I have this, anyone know why it isn't working?? Goal is to return the first Friday after the [Est. Stock Date]. =IF(WEEKDAY("[Est. Stock Date]"=1,[Est. Stock Date]+5,IF(WEEKDAY("[...
user avatar
0 votes
1 answer
9 views

Calculated Column formula to find two values in column

I have a Single Line Text Column(Content). I would like to create a calculated column that returns "Yes" if the Content column contains either of the two words- "Urgent" or"...
user avatar
  • 11
0 votes
1 answer
20 views

If statement comparing a calculated result to a number returns false even if they're the same

Number field "QuantiteStockageConteneur" = 7922.55 Currency field "TauxStockageConteneur" = 0.28 Currency field "StockageDeConteneur_ParPiedCube" = 2218.31 I have tried: ...
user avatar
1 vote
0 answers
41 views

My Column Formatting No Longer Works (and the problem seems to only be on my computer...)

I have a column that is a Risk Index that calculates based on other columns. The equation calculates as following: -50 0 30 70 100 -50 = Pending Review / 0 = Completed, no risk / 30 = Risk Mitigated ...
user avatar
0 votes
1 answer
23 views

Calculated Column using current year (Today)

I need to create a calculated column that would need to show the years since a document was published. Notice that I'm not saying [Created]. The issue is that I have a document library where our ...
user avatar
  • 508
0 votes
0 answers
9 views

I'm trying to calculate the Hitrate percentage of a manager for each week of the month, there are months when we have 5 weeks as well

I'm trying to calculate the Hitrate percentage of a manager for each week of the month, there are months when we have 5 weeks as well. Below is the code I'm using: =IF(OR(HRW01+HRW02+HRW03+HRW04=4,...
user avatar
  • 1
0 votes
0 answers
10 views

SharePoint 2016 - Created Start/End filter columns, but recurring events aren’t working. calculated fields only stamp the first & last event day/times

So I have set up four Calendar Views and four corresponding Overlays to display three colors based on filters: Scheduled Tasks: Category of “Scheduled Task” w/ Blue Overlay color Current Tasks: ...
user avatar
  • 25
1 vote
1 answer
27 views

How can I use the doc ID in a calculated field

The document ID is this: EY3P5SDA5APP-512271551-6 and I would like to isolate the last digit (here 6) using a formula. I tried this formula: =RIGHT([Valeur d’ID de document],LEN([Valeur d’ID de ...
user avatar
0 votes
1 answer
55 views

How to Automate Percentage Complete on Sharepoint List when answers are text

I have a sharepoint list I am trying to figure out how to utilize power automate and flows to calculate a percentage score column that runs an initial calculation and then updates as new selections ...
user avatar
0 votes
1 answer
35 views

SharePoint Calculated Field Formula List Generation

I have a SharePoint list content type made in legacy SharePoint. There are 143 calculated fields in this list. Is there a way to extract a complete list of all the calculations in all the columns at ...
user avatar
0 votes
0 answers
22 views

SPOL Calculated Column Formula Help - Working Days

I’m trying to find the solution to 2 calculated column requirements. I have searched quite extensively and have only found partial, or partially working answers. The two requirements are: Work out the ...
user avatar
  • 1
0 votes
1 answer
24 views

List column that contains the sum of a property of a lookup column in the same list

I have a list of users that contains a lookup column for licenses. Each user can have multiple licenses so this column allows multiple selections. The licenses list has a name and cost column. I would ...
user avatar
0 votes
1 answer
22 views

Sharepoint Online Calculated Column Differences

I have 2 columns, 1 that has a calculated date depending on another column. Call that Date 1. Second Column is another Calculated column. it looks at Date 1 and checks if its overdue. The issue is ...
user avatar
0 votes
1 answer
28 views

Condition based on today's date in calcualted field

I have a calculated column inside a solution Table in Power Automate but I need the condition to be check with a value now() - the current date, not a hardcoded value like this. However when I try to ...
user avatar
0 votes
0 answers
29 views

How do I create a calculated value for a column in SharePoint online

I have a list within SharePoint online. One column is for doc type (choice field), another column is expiration date (Date/time field) and third column is status column(Choice). When the document in ...
user avatar
0 votes
0 answers
9 views

I enter large formula into calculated column and click ok, no errors appear, and when i click edit the column the majority of the formula is gone

I enter a fairly large formula consisting of nested IFs, ANDs, & OR statements and the formula is accepted without errors when I click ok. When I then hit edit to view the formula again, most of ...
user avatar
  • 1
0 votes
1 answer
53 views

Remove Trailing Zeros from Sharepoint List Lookup Field that is based on a Calculated Field

I have two Sharepoint Lists, one of which has a Primary ID field that is a Calculated Field that simply equals the Sharepoint generated ID field. Table 2 has a Lookup field that pulls in this new ...
user avatar
0 votes
0 answers
25 views

Creating calculated columns using data from calculated columns

I tried to create a calculated column which uses data from other calculated columns in the same list. I'm getting an error message, that the columns do not exist even though i can select them from the ...
user avatar
  • 1
1 vote
1 answer
49 views

Calculate the week from a date, Jan 1st = week 1

I'm looking for a calculated column formula which will calculate 1st January 2022 as week 1. I'm in Europe, so, like most of the world, my date field 01/01/2022 = 1st January 2022. I would like 1st ...
user avatar
  • 2,319
0 votes
1 answer
24 views

Can I make a calculated column that uses text in the boolean comparison but returns a number?

I'm trying to make a calculated column with a 5 level conditional as follows: =SI([Impacto Inherente]="Crítico";400;(SI([Impacto Inherente]="Mayor";300;(SI([Impacto Inherente]=&...
user avatar
0 votes
1 answer
27 views

Calculated column, formula to count how much time left before deadline

I have 2013 list (on premises) and I have a column "Deadline date". I need to create a calculated formula which 30, 60 and 90 days before will show such text, 30, 60 or 90 days left before ...
user avatar
0 votes
2 answers
45 views

Date and Time Calculation in Sharepoint Excluding Weekends and displayed in minutes

The code below is working well to calculate the time between two dates and excluding weekends. However, I would like to modify it to just return the number of minutes in number format so I can do some ...
user avatar
0 votes
1 answer
20 views

I want to look at 2 date & time fields and compare that to now to return a status

We have locations that are open or closed for the day. I want to create a list that has a status column that says if that location is open or closed based on two other date and time fields. Example 1: ...
user avatar
0 votes
1 answer
28 views

Date and Time Calculation excluding weekends

I want to figure out the amount of time between Quote Start Date and Quote Complete Time in minutes and exclude weekends. I have tried several examples I found online but I always get a syntax error. ...
user avatar
1 vote
1 answer
77 views

How to remove space from a title column in SharePoint online

I am sure this question has been asked many times, but would someone please be able to guide me with my issue with removing a space between title word, e.g. title "Project ABC" and I would ...
user avatar
  • 23
0 votes
0 answers
16 views

add-SPOSiteCollectionAppCatalog breaks calculated fields

Has anyone else noticed some weird behaviour with sharepoint 365 when after you run. add-SPOSiteCollectionAppCatalog The caculated fields breaks. i.e when you click 'add field' and then choose ...
user avatar
1 vote
1 answer
65 views

Conditional Calculated Date Column

I currently have a calculated column [Retention Date] that is only based on one value, the completion date. This is for certain certificates so I can use them for styling in my DataTable. The issue ...
user avatar
  • 131
0 votes
1 answer
61 views

SharePoint List - Advanced Formula - 3 Criteria

I need to use a SharePoint list instead of an excel and I can't find a way to write the following formula. In the excel I use VBA. The case is: Each user will import the following data: Column A: ...
user avatar
0 votes
1 answer
24 views

SharePoint Online calculated column formula error

I would like to create a simple calculated field, that returns a text if a value is greater than another. Column [Bruttó összeg] is number type. I just copied the formula from the official Microsoft ...
user avatar
0 votes
0 answers
15 views

Calculate Business Days which are Monday - Thursday in this case

This works perfect for standard workdays but wonders where I can update for just M-Thur only IF(ISERROR(DATEDIF([StartDate],[EndDate],”d”)),””,(DATEDIF([StartDate],[EndDate],”d”))+1-INT(DATEDIF([...
user avatar
0 votes
2 answers
48 views

Using calculated value columns using date

I have a SharePoint list that has the following columns: I'm having a hard time making this. I want to make the Status column a calculated value dependent on departure and return. I want to show if ...
user avatar
  • 1
0 votes
1 answer
21 views

More than 19 IF Statements in a Formula in a calculated column

I have the following formula in a calculated column which contains 19 IF statements. I cannot add any more but I need 6 more. Any ideas to solve this. =IF(AND(Likelihood="Rare",Consequence=&...
user avatar
  • 1
0 votes
2 answers
47 views

Averaging Values of Documents Column and Displaying in Document Set Item

I tried creating a calculated column but it just applies it to each individual item instead of averaging the values from each item together. So for example, I have a document set and within that ...
user avatar
  • 131
0 votes
1 answer
23 views

Converting Excel formula to SharePoint Calculated column formula

I'm pretty new to SharePoint calculated formulas and am struggling to convert an Excel formula I have to a SharePoint calculated column formula. The Excel formula is =FLOOR(280-(J5-TODAY()),7)/7&&...
user avatar
1 vote
2 answers
49 views

SharePoint List calculated field syntax

I am unable to get this SIMPLE calculated field to work. Note that I am not a programmer and do not use codes a lot. So please help in details. I have a SharePoint list where I want to get a simple ...
user avatar
1 vote
1 answer
24 views

Calculated Column to show only Month and Year from formula results?

As is, the formula below works perfect for my project. However, I would like to spice it up by having the results just display the Month and the Year of the "Next Test Date". Also, is there ...
user avatar
1 vote
1 answer
26 views

Returning a value based on date of return

Please I need help. I have a column called "Date_Of_Return". I want to create a calculated field to return "SMP" if the arrival date is greater than "01-11-2021" and ...
user avatar
  • 21
2 votes
2 answers
198 views

How to get the change date for a specific column based on its value

I'm new to SharePoint and I'm not sure if the tool can help me with this issue: I have a list with several items to organize activities/projects, as illustrated in the figure. The "Status" ...
user avatar
0 votes
0 answers
22 views

How to display revision number from SharePoint column to a word document

I have tried this method on the below link but it did not work https://social.technet.microsoft.com/Forums/en-US/d7edacd9-3818-4b66-982a-daa1846fbe2a/add-the-sharepoint-version-number-to-a-word-...
user avatar
0 votes
1 answer
25 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 ...
user avatar
1 vote
1 answer
33 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: ...
user avatar
  • 25
0 votes
1 answer
5 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 ...
user avatar
  • 410
0 votes
2 answers
32 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 ...
user avatar
1 vote
2 answers
524 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])...
user avatar
0 votes
1 answer
12 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&...
user avatar
0 votes
1 answer
18 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" ...
user avatar
  • 21

1
2 3 4 5
23