Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
12 views

trying to count business days from start date column and give a date 30 business days from start date column

Aloha, I am trying to calculate a running business day counter from [start date] column. Also trying to calculate 30 business days from the same [start date] column.
rico's user avatar
  • 1
0 votes
1 answer
57 views

Sharepoint List Auto Incrementing ID based off other Column Groups

So I have a SharePoint List that clients need to fill out. I need a column that autopopulates an incrementing ID for each Program Office. I attached an image of how it should look. Can I do this as a ...
Jesse Y's user avatar
1 vote
1 answer
27 views

SharePoint List - Extract Year & Quarter from Date Field

Wondering how I can have the read-only (calculated columns for Year & Quarter) and show nothing if the date field is blank. Currently I have the formulas for these two columns as: Display Year: =...
Ryan's user avatar
  • 11
0 votes
0 answers
25 views

JSON Code based on date and priority

I want to create a due date column (calculated column) that is auto-populated using the date created and priority column, while excluding weekends. In my priority column I have the following options: ...
Jackie's user avatar
  • 1
0 votes
1 answer
15 views

SharePoint Calculated column displays 1905 as default result

I am trying to calculate the previous year of today by using below formula. TEXT(Year(Today())-1,"yyyy") I am using Text() to avoid the extra comma(,) in the output. But the current formula ...
Kailash Sahoo's user avatar
0 votes
1 answer
28 views

Week number within a month Calculated column

I have an Order date column, looking to add a calculated column that will show week number of that month. For example,4th April 2024 should show Week 1, 29th April 2024 should show as Week 5. Count ...
SeerBug's user avatar
0 votes
0 answers
17 views

Need Help . I need to determine the values in the "Final Status" column in a SharePoint list based on certain conditions involving other columns

I need to determine the values in the "Final Status" column in a SharePoint list based on certain conditions involving other columns. Here are the rules: If all columns (Billing Status, ...
Saran's user avatar
  • 1
0 votes
1 answer
18 views

Extract the last word from a string

Is there a way to extract the last word from a string using a calculated field in SharePoint 2016?
AndyK's user avatar
  • 1
0 votes
0 answers
12 views

Save Calculated Column?

I have a calculated column that calculates the year when a contract needs to be reviewed and this feeds our contract plan for the year. For example contract expiring 5/1/2023 has "2023" in ...
kendallyn's user avatar
0 votes
0 answers
14 views

SharePoint/MS Lists Calculated Column text to number wont work

I'm starting to get desperate so any help is appreciated! I want my choice column [Team Name] be read and then a dynamic answer in the form of a number has to be returned. To keep it simple, I want ...
Job's user avatar
  • 1
0 votes
1 answer
20 views

How to do an AND statement in amongst nested IF statements

I currently have a calculated column that involves several nested IF statements: I need to basically, within an IF statement, do an AND statement so two column conditions need to be met. I've looked ...
Harriet Fischer's user avatar
1 vote
1 answer
34 views

SharePoint List calculation using current date

I am relatively new to SharePoint lists and trying to use calculation to determine an action status as either Open, Closed or Overdue. I have tried the formula: =IF(ISBLANK([Date Closed]),""...
Stuey1964's user avatar
0 votes
1 answer
58 views

SharePoint List counting number of days depending upon status

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",...
Priyanka Sharma's user avatar
0 votes
0 answers
39 views

Calculating a due date based off date created and priority excluding weekends

I want to create a due date column (calculated column) that is auto-populated using the date created and priority column, while excluding weekends. In my priority column I have the following options: ...
Grace's user avatar
  • 1
1 vote
1 answer
25 views

Formula for a calculated column that works off values of 2 other calculated columns

I am trying to build a Training Plan that tracks whether or not a person is on track to finish within a set time period. I built 1 calculated column "Calc - Days in Training" to show if ...
Dustin's user avatar
  • 13
1 vote
1 answer
29 views

SharePoint text field user should able to enter 6-digit alphanumeric characters only [closed]

SharePoint text field user should be able to enter 6-digit alphanumeric characters only.
varun's user avatar
  • 11
0 votes
2 answers
48 views

Calculated Column Based on Start and End Dates

I'm trying to create a calculated column for a list that tracks personnel travelling. There are two date columns in the list, one for their departure date and one for their return date. I want a ...
Matt P's user avatar
  • 1
1 vote
2 answers
35 views

Not sure I am doing this right and need help. If Column B is blank Column A should multiply by Column C. If Column B has info B need to multiply by C

Not sure I am doing this right and need help. If Column B is blank Column A should multiply by Column C. If Column B has info B need to multiply by C =IF([Column B]="IsBlank" AND, ([Column A]...
user110949's user avatar
0 votes
1 answer
26 views

SharePoint to show 'Working days left' and blank if other column is marked 'Complete'

I've been looking on this page and others can't seem to get exactly what I'm looking for, not sure if it is possible but I will ask. One column shows 'Delivery Date' so I've used the following to show ...
Adam Richardson's user avatar
0 votes
1 answer
31 views

MAX Formula for Calculated Field or other way for sequential numbering

The Question: How can I create a Calculated column with a formula that works the same way as an Excel MAX formula? Or other way to get automatically sequential numbering of items (00001,00002, 00003, ...
Krzysztof Tataradziński's user avatar
1 vote
1 answer
47 views

JSON to display image based on 100% completion

I have a list where we track an employees performance by awarding badges. When 4 badges are earned, the employee achieves a Pennant. I have a calculated column for Progress that adjusts by 25% with ...
user110812's user avatar
1 vote
1 answer
25 views

Add yrs to Date calculated column not working

I have a date column e.g 14/02/2023 I tried using the formula below =DATE(YEAR(DatePicture+5),MONTH(DatePicture),DAY(DatePicture)) DatePicture is the name of the date column. It has been set to Date ...
naijacoder's user avatar
  • 4,282
0 votes
1 answer
20 views

Calculate column using Month(Today)

I want to calculate month difference from start date - today date using calculate column. I am using this formula: =DATEDIF([Start Date],TODAY(),"M") but I am not getting any result!
Ravi Shirsath's user avatar
1 vote
1 answer
33 views

Formula outcome doesn't appear in the file details

I was in need of column showing me extension of the files, I've made one with this code: { "$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json&...
rocendroll's user avatar
0 votes
1 answer
20 views

Show as blank rather than 0.00% (Decimal showing as %)

How can I set the calculated formula on SharePoint list when the result is 0 (0.00%) to show as a blank and if there is a value do the following calculation =Figure/100? Hope you can help me.
Mark Wadsworth's user avatar
2 votes
1 answer
289 views

How to create a calculated column to pull the year of Date column 1, and if blank, pull year from Date column 2, if that's also blank then put Hold

I am trying to create a calculated column that looks at the Date1 column and pulls only the year into the new column. If the Date1 column is blank, then bring in the Date2 column. If Date2 column is ...
kendallyn's user avatar
0 votes
1 answer
350 views

SharePoint List - Modifying center alignment always changes vertical alignment to top

I am trying to use JSON formatting to center align the values in a SharePoint List. Whenever I apply the JSON column formatting, it also aligns the values to the top. Even when I then specify that I ...
cNiCfR87fKn.'s user avatar
0 votes
1 answer
23 views

Calculated Column next date

I am trying to add a calculated field to a list that takes another field (which allows multi values) and picks up the next date. See Below - Meeting ID is a lookup from another list and is populated ...
Glitter's user avatar
1 vote
1 answer
23 views

Error in my IF statement

My IF statement is shown below and i am using Calculated Function on SharePoint when the word Traffic Signals is used on [Please select which discipline you require access to?], the row (called ...
Jamie Matthews's user avatar
1 vote
1 answer
91 views

ISBLANK and DATEDIF with two date columns where there are sometimes blanks in both

I am trying to figure out the correct formula for my SharePoint calculated column. I have two date columns [Date in Queue] and [Date Completed]. I need to calculate number of days between the two ...
laurunger's user avatar
1 vote
1 answer
21 views

Question on formula

I have a calculated column in SharePoint at the moment, it uses a formula to pull in a month name, number of holidays in the that month and then multiplied by 3. The formula I am using is: IF([Month]=“...
user107779's user avatar
0 votes
1 answer
21 views

Help with Calculated Column Formula on SharePoint

I have a SharePoint List that I need to build a calculated column for but am having issues trying to put together the formula. For the purpose of this forum, the columns needed in the formula are &...
Sam's user avatar
  • 1
1 vote
1 answer
177 views

How to create a calculated column that gives date excluding weekends?

I have a SharePoint list with "Request raised date" and "No. of days" by which the request should be completed. Now, I want another Date column which adds 'No. of days' to the &...
laxmi priya boina's user avatar
1 vote
1 answer
71 views

Count option is unavailable in calculated column

I have a query regarding on SharePoint list. In the column heading, there is an option named "Totals" and under this "None or Count" drop-down is available. I have a "Status&...
Nehad's user avatar
  • 27
1 vote
1 answer
39 views

SharePoint list validation formula issue

This is the first time asking here. I'm trying to write a formula for list validation but I cannot understand what I'm missing. For this formula I need to chain 2 conditions [Start date]<= [End ...
Radu's user avatar
  • 11
1 vote
1 answer
153 views

Cannot get past syntax error

My coworker has written this code but continues to get a syntax error. We've checked field names and all are correctly spelled. Any ideas what else could be wrong? =IF(ISBLANK([Start Date]),"&...
Therron Thomas's user avatar
0 votes
0 answers
35 views

Formula Help Needed: Calculating Dates to Exclude Weekends

I am trying to set up several dates on a list in SharePoint. The dates all relate to each other, and I want to exclude weekends when calculating these dates. I have three date columns: “Request Date” -...
Sara Lons's user avatar
0 votes
1 answer
141 views

Sharepoint. ID Column exists in list, and all items view but not in list settings

How do I find my ID column? It exists in my List and in my all items view but not in list settings. I am trying to do a second field where I concat the ID to a string. Where is it? how come I cant ...
Jonnyboi's user avatar
1 vote
1 answer
32 views

SharePoint Calculated list IF statement based on two columns results

I have columns called Refresh Due and Refresh Priority and I want the results in these columns to provide a result in a third column called Priority Order. Refresh Due is a calculated column that ...
Michael Powis's user avatar
0 votes
0 answers
41 views

SharePoint List Nested IF statatments

I'm trying to write a code that checks the status of a column and if it's blank it then checks a different column and so on until it returns data. This is my syntax so far but it comes back as invalid:...
Heather's user avatar
1 vote
1 answer
70 views

SharePoint Site column of type Single line of text with specific validation expression

I'm looking for a validation formula to validate a site column in SharePoint site and make it only accept only lower case English characters, numbers, and only hyphen, I tried below formula but it's ...
Mohammad Akilan's user avatar
1 vote
1 answer
2k views

SharePoint calculated column convert text to number?

Actually, I have searched about this topic. But I didn't get why it is useful to convert text to a number. I'm new to SharePoint.Can anyone please help me with that? And give any example based on that ...
Chandrika Kambala's user avatar
0 votes
2 answers
3k views

Is it possible to get email from person column in SharePoint calculated column?

Is it possible to get email from person column in SharePoint calculated column? Please write it, if it is possible.
Chandrika Kambala's user avatar
0 votes
2 answers
232 views

How to get first letter of second string in SharePoint calculated column?

I have a SharePoint list, where I got the first letter in a calculated column by using the LEFT function. How can I get the first letter of a second string?
Chandrika Kambala's user avatar
0 votes
1 answer
4k views

SharePoint list calculated column Concatenate Function

I have Created a Date and Time column, Based on on that i have taken calculated column to concatenate Text and Date. But it is not showing Date format in calculated column. Can you please help with ...
Chandrika Kambala's user avatar
0 votes
2 answers
78 views

Help with formula for calculated column in SharePoint

I have a SharePoint choice column entitled month of year, I want to look at entries where the month selected is August, I want to then look at any holiday entries for the month of august which are ...
user107779's user avatar
1 vote
1 answer
37 views

Calculated Column: Nested If

I am new to SharePoint and I'm trying to enable a calculated column in a SharePoint list with the following formula but it's not working quite well. It is not throwing me any Optimize nor Test ...
Mariana's user avatar
  • 11
1 vote
2 answers
32 views

Can you please show me any example related to this AND Condition in SharePoint Calculated column

I have taken a SharePoint list based on budget. I wanted to take a Calculated column named Budget Scarcity based on Budget Amount and Used Amount. I wanted to Use AND Condition, but was getting errors ...
Chandrika Kambala's user avatar
0 votes
1 answer
845 views

SharePoint calculated column with hyperlink

I have a SharePoint list as "Training Courses" and inside this, I have added a calculated column named "Website URL". Here, My requirement is if a user enters the website name in ...
Ganesh M's user avatar
1 vote
1 answer
552 views

SharePoint calculated column replace all spaces

This is my requirement: Here, I have taken a single line of text column with 2 spaces in the column field. I have used that column as a reference in a calculated column. By using a formula I can able ...
Chandrika Kambala's user avatar

1
2 3 4 5
26