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

How to get a particular value in the calculated column

I am trying to implement the following code in a calculated column named [Valid] in a document library in modern SharePoint online. =IF([Valid Until]-TODAY()>=0,"Valid","Expired"...
0
votes
0answers
13 views

Button on SPO Page that copies the URL of an item in a list view web part with a checkmark next to it

Basically, if ONE document in a document library LVWP is checked, a button should become active. When clicked, the button will copy that document's absolute encoded URL to the clipboard. It doesn't ...
0
votes
1answer
17 views

Priority Due Date column sharepoint online

I need to setup a Due Date calculated column on an SPO list and whilst I've managed to work out the formula for days, I cant quite work out hours?! I have SLA priorities on my list as per the below: 5=...
0
votes
1answer
35 views

Calculated Column with TODAY() issue

Using the following: "If Authorization Date is null, calculate the difference between Receive Date and today; If Authorization Date is not null, calculate the difference between Receive Date and ...
0
votes
1answer
33 views

My Sharepoint formula not working

=IF([Sett. Start]<=Today,"Visit Due",IF(ISBLANK([Visit Notification No.]),"Visit Not Due","Visit Done")) I am using above formula in SharePoint List but it is working ...
0
votes
3answers
48 views

=IF(ISBLANK([Last Update]),“”,TEXT(NOW(),“dd/mm/yyyy”)-[Last Update]) is retruning negative numbers

I have the following formula inside a calculated column:- =IF(ISBLANK([Last Update]),"",TEXT(NOW(),"dd/mm/yyyy")-[Last Update]) but today is 27/08/2020, and on some cases where ...
0
votes
1answer
36 views

Calculated Columns - Comparing multiple columns with IF statement

I am fighting with SharePoint calculated columns and trying to compare multiple columns. The SharePoint list has the following columns: Completed Date - Date Completed - Yes/No Due Date - Date ...
0
votes
1answer
23 views

Initiate a Work Flow Every 24 hrs

I have the need to initiate THE MOST SIMPLE ACTION possible every 24hrs in an SP List. The action doesn't even have to do or mean anything, just kick-off in a way that it impacts the entire SP list; ...
0
votes
1answer
35 views

Minus 5 hours 30 minutes from a date

I have a column of type as date and time. I want to minus 5 hours 30 minutes to produce a new time in a new column - Please advise?
0
votes
1answer
16 views

Calcualted column formual “=TEXT(NOW(),”mm/dd/yyyy“)-[Last Update]” will show 44,055 if the [Last Update] column is empty

I am working on an online SharePoint site, and I created a calculated column with the following formula:- =TEXT(NOW(),"mm/dd/yyyy")-[Last Update] now the formula is working well if the [...
1
vote
2answers
21 views

How do I create a calculated column that displays Yes or No if ANY other columns in the row have the value “Yes”?

I have a series of 3 Choice columns that are populated by a MS Form to be either "Yes" or "No". I am wanting Column4 to show Yes if ANY of the columns 1 2 or 3 contain the value &...
0
votes
2answers
66 views

Calculated columns cannot contain volatile functions like Today and Me

I am working on a custom list inside a SharePoint online site collection. and i have a custom column named "Last Update" of type DateTime, and i want to create a calculated column to show ...
0
votes
2answers
33 views

SharePoint Date Flow

I have a list that has a CurrentDate column. With no more SharePoint Designer, where someone once helped me build code for this; as I'm really not very good at any of this to begin with), how can I ...
1
vote
2answers
20 views

Calculated column formula not working when referring to a Yes/No type column?

I am working on a SharePoint list validation to automate some process. I have Column A which is a Yes/No type column and I have Column B which is a calculated column that will take input from column A....
0
votes
5answers
38 views

Sharepoint Calculated Compliance Column

I have an SharePoint list with columns: Title (Single Line Text column) DteofAwrd and CurrentDte (both date columns) ComplianceStatus (calculated column) I am using the below to determine compliance ...
0
votes
0answers
30 views

Calculated Column to add days to a date

I am needing to calculate a column in SharePoint based on certain conditions. Expected Release Date = Is based on the Due Date captured. Expected Release Date column must auto-populate for that week ...
0
votes
2answers
25 views

Sharepoint calculated column IF function - Syntax error

No matter which syntax i use, sharepoint throws me a syntax error on IF function. here is what i have tried so far = IF ( [colA] = "dddd"; "yes" ; "no" ) = IF ( [nr1] <...
0
votes
2answers
20 views

Sharepoint list have german date convert into Monthnumber

I have a German client sahrepoint list and I want to convert month from date column in number. Like Month and Year in German: Want to Extract Month and year in separate column for further calculation ...
1
vote
1answer
27 views

Calculated Date Difference Question

Before submitting this question, I've tried researching this in the forums and have attempted multiple variations of suggested formulas with no success. So apologies in advance for asking what seems ...
0
votes
1answer
26 views

Nested IF Statement in SP List Calculated Column

I need to create a Nested If statement based on several columns. Column 1. CurrentDate (Date) Column 2. DteofCQ (Date) Column 3. CQTitle (Text) Column 4. ComplianceStatus (Calculated) There are 8 ...
1
vote
1answer
42 views

Calculated Column - Days Difference - Syntax Error

I have a SharePoint List and I'd like to have a column to calculate the days it take to solve a ticket (Solution date - Submission Date). I tried to create a calculated column, by using a formula = ...
1
vote
2answers
19 views

Multiple IFS in Sharepoiint Calculated columns

I am trying to write a formula in a calculated column that would populate shift hours base on shift name. The Shift title column is names "ERSShift". The different shifts available are "...
0
votes
0answers
14 views

Column Default Value Based on Root URL

I have a tab in an MS Teams team where users can view our upcoming corporate training sessions (i.e. modern Events). In each event description, I am putting a link to a sign up form. The sign up form ...
0
votes
1answer
25 views

calculated column missing in designer workflow dropdown

I have a calculated column in a list and I want to update that column value from SharePoint designer workflow but when I am trying to update the field in workflow, calculated column is not showing up ...
1
vote
1answer
30 views

Calculated column in SharePoint list - Conditional formula for finding difference

I am working on creating a leave tracker list. For that, I have added a column for Leave Type with 4 choices with 1 choice being company off. I want to add another column that says => Comp offs ...
1
vote
2answers
29 views

Adding days on calculated column from monday to friday

I need to add a calculated column in SharePoint where I have to add +1 day from Monday to Thursday and +3 on Friday but I don't know how to do it. I did some tests with WEEKDAY without success.
2
votes
2answers
59 views

Calculated Column: Prevent date from changing - SharePoint 2013 online

Need some help please - currently working on SharePoint 2013 online. I have a choice column (drop down) called 'Stage'. In 'Stage', I have 3 choices; Start Pause End I also have 3 calculated columns ...
0
votes
0answers
18 views

Start Time (EventDate) when used in calculated field, showing minus 1 day if AllDay is selected

I am working on a SharePoint 2010 Calendar. Creating a column with a calculated field type. Using =Text([Start Date]), "ddd, dd, mmm") and for some reason, When I am selecting the Event as ...
0
votes
1answer
26 views

Add a calculated column with if statements

New in this forum. And I have a quick question: I have a choice column with this values: Kg Lb Ton And I would like to add a column that multiplies if I choose Kg or Lb or Ton and convert ...
0
votes
1answer
19 views

SharePoint time difference in minutes - wrong result

I created a simple SharePoint list and I am having problem with a calculated field. I have a "Duration" field that calculates the minutes between the start and end date/time columns, using the formula:...
0
votes
1answer
22 views

Populate Sharepoint column with the dates of the next 3 Thursdays

I am trying to setup a list that captures signups for a weekly meeting that happens on Thursdays. For each Thursday, there can be up to 4 people signed up on the meeting agenda. I was hoping to find a ...
1
vote
1answer
22 views

Issues with calculated field syntax

Our school district uses O365 Sharepoint in the cloud. I've been tasked with creating a calendar in Sharepoint for all users for conference rooms reservations. I have NO experience with Sharepoint. ...
0
votes
1answer
24 views

Sharepoint list with calculated column - formula IF does not work

Working on a SharePoint list with a calculated column with a date, which I want to make dependent on priority (column is called Prioriteit), and date of creation (Datum melding). I made this formula ...
0
votes
2answers
22 views

extract “all” numerics from text string

I have a Sharepoint Online list with a text field for a contact called Mobile Phone... I want to extract the numerics only... (111) 222-3333 would be 1112223333 +99 111-222-3333 would be 991112223333 ...
0
votes
1answer
30 views

SharePoint Calculated Column by searching another column for various strings

I am working with a SharePoint 2016 list that contains one column with names and other values. I want to use a calculated column to search that "name" column and return another value if that "name" ...
0
votes
1answer
23 views

How to calculate the difference between two data in the same list column

I want to know how to calculate the difference between two data in the same column of a list. It is useful if we are monitoring the changes (daily-monthly-etc). TX for your suggestions on how to make ...
0
votes
2answers
34 views

How to have validation for calculated column

I am working on a calculated column that take value from other two different columns. The formula is as this: =IF([Detect-Rental/Lease]=1,IF([Detect-Rental/Lease Taxonomy]="Yes",TRUE,FALSE),TRUE) ...
1
vote
1answer
36 views

SharePoint List - Time Calculation

We have a change control SP list and do aging metrics on how long an item is open. I have a calculated field to calculate how long an item has been open, but am getting a negative serial date as a ...
0
votes
0answers
28 views

Need more if statments in calculated column

I have a problem with calculated formula, this take the information from a choice column. The problem is that i have 23 choices, and the calculated column only permit 20. When i add the 21 if, it ...
1
vote
2answers
62 views

Calculated column from a multiple lines column

I made this formula for a calculated column that works from with single line columns, but am unable to make it work with a multiple line column. =IF(ISERROR(FIND("flight",[shipping])),"ground","...
0
votes
0answers
8 views

Adding Column that links to specific document automatically

I wanted to create a column in Sharepoint that will be able to calculate a link based off another column. So for instance I have a Sharepoint list with all these documents in which we specify "related ...
0
votes
0answers
16 views

Sharepoint 2013 Auto Increment Column

I've read a bunch of articles on how to do this, but I haven't succeeded in making this work. So I have SP Designer 2013, but due to my Gov. restrictions, I can only utilize 2010 workflows. I'd like ...
1
vote
2answers
51 views

Increase number of decimal places in SharePoint calculated column while list exceeds the list view threshold

I am facing an issue while I need to increase number of decimal places of list calculative column. I need it in SharePoint online - unfortunately the list contains more than 40K records (and ...
1
vote
1answer
32 views

What is the formula to calculate working days between two dates with Fridays & Saturdays as weekend!

What is the formula to calculate working days between two dates on lists SharePoint? Keeping in mind that the working week here in Dubai is Sunday to Thursday - Fridays and Saturdays are the weekend. ...
0
votes
0answers
9 views

Auto-calculate Average in Range

I have a user that wants to convert her Excel file to a SharePoint list and use the same formulas. I have one column that is an Average of the cells in a range over the column next to it. Example: ...
1
vote
1answer
61 views

How to set date for 2 weeks out for an automated reminder

I have a SharePoint list that is populated with ticket data. There are two primary columns "Open Date" and "Calculated Date" I'm trying to figure out how to set the calculated date 2 weeks out from ...
1
vote
1answer
9 views

Marking item as “Delivery not met” sharepoint list

New to SharePoint lists.. trying to find a way to mark items that did not meet the deadline. I have the column "Expected Completion Date" and "Date of Completion" (Both are in mm/dd/yyyy format). I ...
1
vote
1answer
21 views

Calculating Formula for days and text

Trying to write a formula that calculates the expected completion date based on the priority of the project day it was assigned. For two of the priorities, it needs to be a text response in the ...
1
vote
1answer
35 views

Calculated column: If this than that, with a calculation

I have a column named Soort. It has 3 stringvalues. One of them is Brandstof. There are 2 other columns: AantalKm and Km-vergoeding. They are both numbers fields. And there is a KostenBrandstof column....
1
vote
2answers
31 views

Calculated Column as Title on SharePoint Calenar

I am working in SharePoint to create a calendar that will pull the information from the "Content Category" column and the "Title" column into the title field. To do this, I am trying to create a ...

1
2 3 4 5
20