Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
0 votes
1 answer
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 ...
Jonathan's user avatar
  • 101
0 votes
1 answer
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 ...
Harriet Fischer's user avatar
1 vote
1 answer
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]),""...
Stuey1964's user avatar
0 votes
1 answer
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",...
Priyanka Sharma's user avatar
1 vote
1 answer
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 ...
Dieter's user avatar
  • 11
0 votes
0 answers
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: ...
Grace's user avatar
  • 1
1 vote
1 answer
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 ...
Dustin's user avatar
  • 13
0 votes
1 answer
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 ...
SPgrunt05's user avatar
0 votes
0 answers
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 ...
Mandi Oliver's user avatar
0 votes
0 answers
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 ...
kendallyn's user avatar
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
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 ...
Adam Richardson's user avatar
0 votes
1 answer
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, ...
Krzysztof Tataradziński's user avatar
0 votes
1 answer
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!
Ravi Shirsath's user avatar
0 votes
1 answer
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.
Mark Wadsworth's user avatar
2 votes
1 answer
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 ...
kendallyn's user avatar
0 votes
0 answers
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 ...
Caleb10562's user avatar
1 vote
1 answer
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 '...
21200506's user avatar
0 votes
1 answer
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 ...
Glitter's user avatar
1 vote
1 answer
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 ...
Jamie Matthews's user avatar
0 votes
1 answer
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 - ...
Travis Horne's user avatar
0 votes
1 answer
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 ...
kkaxm's user avatar
  • 1
1 vote
1 answer
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 ...
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
1 vote
1 answer
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 &...
laxmi priya boina's user avatar
0 votes
1 answer
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 ...
Nehad's user avatar
  • 27
1 vote
1 answer
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&...
Nehad's user avatar
  • 27
1 vote
1 answer
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 ...
Radu's user avatar
  • 11
1 vote
1 answer
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]),"&...
Therron Thomas's user avatar
1 vote
1 answer
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 ...
Nehad's user avatar
  • 27
0 votes
0 answers
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” -...
Sara Lons's user avatar
1 vote
2 answers
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 ...
Just Somebody's user avatar
0 votes
1 answer
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 ...
Jonnyboi's user avatar
1 vote
1 answer
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 ...
Michael Powis's user avatar
0 votes
0 answers
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:...
Heather's user avatar
1 vote
1 answer
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 ...
Mohammad Akilan's user avatar
0 votes
0 answers
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 ...
Sam's user avatar
  • 1
0 votes
1 answer
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 ...
Chandrika Kambala's user avatar
0 votes
2 answers
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.
Chandrika Kambala's user avatar
0 votes
2 answers
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?
Chandrika Kambala's user avatar
1 vote
1 answer
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 ...
Ryan's user avatar
  • 13
0 votes
1 answer
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 ...
Chandrika Kambala's user avatar
0 votes
2 answers
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 ...
user107779's user avatar
1 vote
1 answer
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 ...
Mariana's user avatar
  • 11
1 vote
2 answers
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 ...
Chandrika Kambala's user avatar
1 vote
1 answer
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 ...
Chandrika Kambala's user avatar
2 votes
1 answer
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 ...
Ganesh M's user avatar
0 votes
1 answer
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 ...
ChasEpes's user avatar
  • 109
0 votes
1 answer
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'...
Brax's user avatar
  • 25
0 votes
1 answer
231 views

How to use Regex in a Calculated Column's formula for finding a string pattern in another column?

I'm trying to generate an ID on emails that come on my site. Essentially, when the email subject matches the regex, it generates an ID based on that pattern. My question is how do I use regex on SP's ...
NoobNewb's user avatar
  • 115

1
2 3 4 5
17