People who code: we want your input. Take the Survey

Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
1
vote
1answer
24 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
20 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(...
2
votes
1answer
1k views

How to use a lookup column's additional field in a workflow?

Background I have two lists. One is a list of voltages and their corresponding costs. This is to be used as a lookup for other lists. Voltage Cost 120 2.50 240 ...
0
votes
1answer
15 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 ...
0
votes
0answers
27 views

Create dynamic calculated column for filtered list view

I have a SharePoint list of 20000 items, where each item has 11 different columns, with values (tags) as per the item, that I add manually. So, I want to create a new column with a URL where the user ...
1
vote
1answer
22 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
13 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
3k views

Calculating overdue status in a Sharepoint list using calculated column

Hoping someone can help as I am relatively new to Sharepoint. I've created a list to track completion of internal audit activity. It includes a status column and due date column. I'm trying to ...
1
vote
2answers
42 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
22 views

Power Automate - Set Column value to equal value of another Column in same list

I have a modern list with about 5,000 entries. My client has added two columns since creating all this data, and I need to set one column to equal the value of the other (doing this manually will ...
0
votes
1answer
33 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
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
1k views

Copy to Clipboard Button in a Calculated Column (SharePoint Online)

I have a Text field called urlText in a Document Library List. Everytime a document is created, a workflow populates this field with the URL of the Document. I want to make a calculated column/button ...
1
vote
2answers
51 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 ...
2
votes
1answer
19 views

Add validation on numeric column when user fills control using coma

I need to add validation on a numeric column. An error should be when the user fills the control with a decimal number using a comma instead of a dot. I have a formula which looks like this: =AND(IF(...
0
votes
1answer
924 views

DATEDIF function to also work with negative numbers?

I am trying to write a very simple equation as Calculated Column on SharePoint List. This equation works easily in Excel, but I'm having trouble with it on SharePoint List. I am trying to find the ...
1
vote
3answers
35 views

Calculated Column Yes/No based off 3 Yes/No columns

If column A, B & C all show yes then column D should also be yes If column A, B or C shows no then column D should be no Can somebody help me write a formula for this to use in a SharePoint ...
4
votes
1answer
4k views

How to filter tasks for previous calendar month

How to setup view, that would show all "Tasks" for previous month ? I can find first and last day of previous month. End of previous month: End_of_previous =DATE(YEAR([Activity Date]),MONTH([...
1
vote
1answer
31 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
24 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
2answers
36 views

Convert Excel Formula to Sharepoint Calculated formula

I'm having difficulty converting this Excel Formula to Sharepoint calculated formula. Hoping someone can help. =IF(OR($F13>=TODAY(),ISBLANK($F13)),0,IF(ISBLANK($G13),NETWORKDAYS($F13,TODAY(),...
1
vote
1answer
34 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
39 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
2answers
42 views

SharePoint list: Conditional required field - Hhow switch off

In my SharePoint list there are two columns: A and B (both of them are required). Scenario: If user will input value in column A, he don't need fill column B. And reverse, if the user enters the value ...
1
vote
1answer
25 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
1k views

How to Set Specific Date and time in Field of SharePoint List

I have a requirement where we need to create a view in a sharepoint to filter items created after 4pm on Friday until next week 4pm on friday. This is what i have accoimplished so far. Created a ...
0
votes
2answers
40 views

List Validation Formula not working

I need your help to fix my issue, basically what I want is when users select B from choice filed, the next column become mandatory. Below formula doesn't work: =IF([A]="B", [TEST] = " &...
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
vote
2answers
940 views

SP2013 : Overriding Thumbnails column in PublishingImages library

I'm really stuck with this one, so if someone has a little time to help me on this... What i want : I have a pictures library in a site. It is even a PublishingImages library. a lot of my images are ...
0
votes
1answer
1k views

Sharepoint 2010 Calculated Column: How to get value before item gets modified?

I have a list that has a Status-field. If the status changes, a modified date in another column should indicate, when the status has been changed. My idea was to create a duplicate of this Status-...
1
vote
2answers
16 views

Calculated column for differences between two column dates with blank check if blank use another column for difference - Sharepoint list

I am trying to create a calculated column which shows the number of days' difference between two columns which have dates in them. I understand that I can get this with the following formula: =DATEDIF(...
0
votes
2answers
1k views

SharePoint 2013 calculated column multiple if statement error

can you please help me evaluate what is wrong with the if statement below, i need to use it in a SharePoint 2013 calculated column, but I keep getting an error. =if([Today]-[Last Reviewed Month/...
0
votes
3answers
3k views

Referencing Choice Field in Calculated Columns

I have a question regarding Calculated Columns. I have a Column Called "NextMileStone", this column can contain "PM010", "PM020, "PM040", "PM070", or some other choices that would be the "else" ...
0
votes
2answers
15 views

Calcualted field for created date -today not working

I am trying to make a field to show how many days it has been since this item was created. =IF(ISBLANK([Created]),"",TEXT(NOW(),"mm/dd/yyyy")-[Created]) Above is the formula used ...
1
vote
1answer
13 views

How can I set a special format in a column or leave the field blank

I have a column that is called APC Standard. In this column I want to set the following format APCxxxx (APC + 4 numbers). I also want to have the possibility to leave the column blank. I have already ...
1
vote
3answers
39 views

Impact on Performance of Calculated Columns

I have an SP Library. I created several calculated columns in the Library (using LEFT, RIGHT, MID) to break-up the content of the 'Name' column. Everything works fine; however, I was having a ...
0
votes
1answer
30 views

Calculated column for IF not working

I have created a calculated column to see if the target has been met. I have tried different combinations of IF formulas. Am I missing something? Thank you =IF([Response date]=0,"Not met",...
2
votes
1answer
46 views

Calculated field for date columns, if date1 has a date use it, else if date2 has a date use it, else use date3

I am working on building a calculated field using 3 date columns on a list and I am having difficulties due to being 3 dates and If/Else. Basically it should calculate a date based on if date1 is not ...
1
vote
2answers
22 views

How to total the number of selected columns that have string data?

Within a SharePoint Online list, if I have a record that has 6 columns like so... ID: #id of this record Title: "my first test" Step 1: "apple" Step 2: "grape" Step 3: ...
1
vote
1answer
24 views

Calculated column, if box is checked then date+6 month if not date+3 month

I have a SharePoint list with 3 fields: Date: the user enter the info Prolongation: Checkbox Second date: this is a calculated column. This is what I want: if the "prolongation" box is ...
0
votes
1answer
13 views

Filter a view based on an array of values

I'm trying to create a view to temporarily expose the various documents that are missing a specific column value. I thought I could create a calculated column with a simple clause that states =IF([...
0
votes
1answer
55 views

find text in calculated field

All, i am trying to extract part of a string in a calculated field. The calculated field is looking in the title field, of an item in the library, for the word "DIS". The formula I am using ...
0
votes
1answer
27 views

IF OR / DATEIF calculated column

I have a calculated column that returns days open for job listings. =DATEDIF([Requisition Open Date],TodayDate,"D")-IF(WEEKDAY(TodayDate)=7,FLOOR((DATEDIF([Requisition Open Date],TodayDate,&...
1
vote
1answer
7 views

Column 1 and 2 are equal or the same then column 3 defaults to yes

I want to change a column to yes if two other columns are equal, so same title and report week. So if report week column and title are the same, then duplicate entry is yes. =IF[Report week][Title]<...
1
vote
2answers
35 views

SharePoint List calculated column based on three different columns values

On one side, there are four dropdown columns (Scope, Time, Resources and Budget) that can contain only one the following values: Green, Yellow and Red. On the other side, I want to make "Project ...
0
votes
2answers
22 views

What is wrong with my calculated column formula?

I have a SharePoint list which contains a column which displays a Custom Item ID created by concatenating the ID field and the last 2 digits of the year (like this 01-21). In some circumstances it is ...
0
votes
1answer
43 views

Calculated column with IF(AND(OR statement to derive a value

I would like to use an IF(OR(AND function (or a function that works) to obtain an answer of 1 or -100 within a SharePoint list. My formula works in Excel but not in SharePoint. =IF(OR(AND(Q10="NO&...
0
votes
1answer
22 views

The Function Sum(IF(AND())) Statement is not calculating correctly

If my [STARTDate] = 12/24/2020 AND [ENDDATE] =1/4/2021 It gives me a total of 3 days. SUM( (IF(AND(DATEVALUE("12/24/2020") >= [STARTDATE],DATEVALUE("12/24/2020") <= [...
0
votes
1answer
27 views

Calculate SharePoint Column for unique expiry dates

I am building document library on SharePoint Online to store employee training certificates that can monitor their issued and expiry dates. The validity period for each certificate is different ...
0
votes
1answer
14 views

2 Lists - Linking together, having trouble

Company description - Widget Rental Services 2 Lists - List 1 = Customer Order/Scheduler (Non Calendar) List 2 = Inventory/Asset List When inputting customer order on list one, we would like to book ...

1
2 3 4 5
13