# Questions tagged [calculated-column-formula]

Question related to the Calculated Column

828 questions
Filter by
Sorted by
Tagged with
6 views

### Calculated column, Greater of two dates < Today If formula

I want to see if the greater of [date1] and [date2] is less then today. Currently i have it for one column - =IF([date1]<TODAY(),"Yes","") But how do I make this formula to ...
• 101
15 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 ...
1 vote
28 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]),""...
27 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",...
1 vote
14 views

### Validate an entry is within a range

Any help with this would be really appreciated! I have 2 columns both of type number (OrigDensity and TestDensity). I would like to validate as a user inputs TestDensity it must be +/- 0.05 of ...
• 11
30 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: ...
1 vote
21 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 ...
• 13
16 views

### Error in SharePoint Duration Calculation Formula

I have three columns - a start date/time, an end date/time, and a duration. I found a guide for setting up the duration column to calculate plain text based on the time/date columns, but something in ...
20 views

### Calcuate a Due Date based on 3 Business Days

I would just need to calculate a Due Date column based on 3 business days from an Activity Date for a SharePoint List column. For instance I could do =[Activity Date]+3, but this formula would not be ...
19 views

### SharePoint Calculated Column Exception

I have a SharePoint List that calculates various fees and taxes for products. The fees and taxes are 99.9% the same across the board but I have this rare case where these 2 products that need a to ...
1 vote
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]...
24 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 ...
28 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, ...
18 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!
19 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.
137 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 ...
12 views

### Difference between two Time Stamps in Minutes Excluding Out of Business Hours

I want to know if it's possible to calculate add minutes to a Created Time stamp in Only Business Hours (09:00-17:00). Example: 16:00 - 17:30(current time) = 60 min 08:50 - 09:10(current time) = 10 ...
1 vote
99 views

### Making required condition in SharePoint list dependent on another field

I have a SharePoint list with several choice, date, text and yes/no fields. I want to make some fields conditional on another field containing a certain word. So for example, I have a field called '...
• 23
17 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 ...
1 vote
20 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 ...
52 views

### SharePoint Online Modern Form Conditional Formatting (Column Rules)

I am working on a SharePoint Online Modern Form solution using the OTB conditional formatting. There are three rules that I am trying to apply, here is the example. Two Columns: COL1 - Choice Field - ...
28 views

### My Syntax Error Calculation in SharePoint List is not worked T_T

I have so so BIG problem!! So, I'm trying to generate the verdict syntax calculation, but it shows the wrong answer. Please help me T_T. The pictures show the filled value from 2 columns before. In ...
1 vote
49 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 ...
1 vote
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]=“...
1 vote
74 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 &...
435 views

### Set field as mandatory if the field is dependent on another field

Can I set a field as mandatory if the field is dependent on the status? Below is the form to insert information for a new plan. How to set Purpose of Visit field as mandatory. If I use the below ...
• 27
1 vote
38 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&...
• 27
1 vote
28 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 ...
• 11
1 vote
72 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]),"&...
1 vote
66 views

### How date can be dependent on status changing

I developed a travel plan list on SharePoint. In the plan, for travel, there are 3 drop-down stages: Planned Completed Cancelled But the issue is anyone can select the "Completed" status ...
• 27
27 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” -...
1 vote
54 views

### Microsoft LISTS Validation Settings question

In my list I have 3 columns, one titled 'Review Status', one titled 'Type of System' and one titled 'Needed Information'. I am trying to write a validation that says If the Review Status equals ...
93 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 ...
• 99
1 vote
30 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 ...
36 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:...
1 vote
66 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 ...
7 views

### Help with Calculated Column Formula

This is probably very simple, but I can't seem to get it working. I need to build a calculated column formula based on the below in my SharePoint list. Calculated Column Name is called Status The ...
• 1
1k 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 ...
2k 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.
145 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?
1 vote
22 views

### Solution for Creating a Formula that Utilizes Two Separate Columns As Conditions For The Output of a Calculated Column

Hi SharePoint experts, I have two columns in a Sharepoint List, one titled "Budgeted Amount" and the other "Contract Expiration Date". What I'm trying to do is create a calculated ...
• 13
2k 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 ...
62 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 ...
1 vote
24 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 ...
• 11
1 vote
30 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 ...
1 vote
328 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 ...
654 views

### SharePoint calculated column if contains text

I have a SharePoint list (Issue Tracker), here I created a calculated column like Product Name and the formula is: =IF((FIND("Laptop",Title)),"Laptop") And, My requirement is when ...
• 21
48 views

### SharePoint Validation: If Empty or Null

I need help with a validation formula in a SharePoint Text column where: column can be empty ( the default state when list is opened) column can be null (the state after a value is deleted) must be ...
• 109
50 views

### Calculated column Update daily

I have a column that calculates the days until expiration for certifications. To do so I use the Today function: =[Certification Expiration Date]-TODAY() I have noticed that this type of column doesn'...
• 25