Skip to main content

Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
0 votes
1 answer
19 views

Calculated column in MS Lists not returning any output?

I'm trying to populate a simple Calculated Column in MS Lists to provide a Risk Assessment outcome. I've tried this in Excel and it works fine, but whenever I save the Calculated Column in Lists / ...
ypowt's user avatar
  • 3
0 votes
1 answer
16 views

Calculated Column IF statement limit?

I am trying to assign numerical values based on a list of countries on a SharePoint List (SharePoint in Microsoft 365). I want to autofill a column with numbers based on another column. I have no ...
user111595's user avatar
0 votes
1 answer
14 views

How to calculate difference in the same column

I have three SharePoint list columns named as follows: Athletes name as choice Counters as date time Difference as calculated field. I want the formula to calculate the difference between the ...
RYPRO RY's user avatar
0 votes
2 answers
20 views

IF(OR(ISNUMBER(FIND( Issues nested SharePoint library

I'm trying to create a complex calculated column where it looks through the title of a document to pick out keywords and display a code based off which set of keywords it finds. For example, if the ...
woolway1218's user avatar
1 vote
1 answer
33 views

Calculated column based on another column

I'm trying to create a calculated column based on a status column. The status column is a multi choice column (but I can change in a text column). For example: if the status is "xxxx", I'd ...
Massimo Borrelli's user avatar
0 votes
2 answers
25 views

Calculated Column based on 2 columns, one a choice the other a number

I am trying to create a calculated column with multiple conditions. So, the Application “Status” is “Over Due”, if the Stages column is still “Stage 1” and the “Days since Application” is 5 days or ...
DAz's user avatar
  • 1
0 votes
1 answer
25 views

I need to calculate the week number of a specific date

I need to calculate the week of a specific date. This is not working for me: =WEEKNUM([Target Date],1)
Carolina Messias's user avatar
0 votes
0 answers
4 views

can you use Lists calculated column to calculate dates ignoring specific days, (eg. not counting saturday, sunday.)

Aloha, i am trying to create a calculated column that takes a [start date] and calculate 30 business days forward ignoring saturday and sunday as [expiration date] eg: [start date] - [expiration date] ...
rico's user avatar
  • 1
0 votes
0 answers
13 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
7 views

Calculate hours using a start time and end time column

How can you get the hours to display in a decimal for example someone work 8:15 to 4:30 and I want it to display 7.25 hours? I used this formula but I cant get minutes displayed as above: =IF(ISBLANK([...
Marnee Wade's user avatar
1 vote
1 answer
95 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
30 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
47 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
2 votes
2 answers
43 views

Require column based on another column

I am trying to make it that my columns "Event location city" and "Event location country" are required ONLY if Event type is In person or Hybrid. Is this possible?
user111595's user avatar
0 votes
1 answer
26 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
1 answer
27 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
21 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
39 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
94 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
18 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
41 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
26 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
26 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
26 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
22 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
36 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
27 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
35 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
21 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
21 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
441 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
365 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
30 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
27 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
86 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
30 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
111 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
22 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
229 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
2k 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
114 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
44 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
220 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
83 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
38 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
101 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
159 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
  • 109
1 vote
1 answer
41 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

1
2 3 4 5
17