Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
1 vote
1 answer
8 views

Sharepoint List - Calculating weekdays between two dates ignoring blanks (Project Registration Date to Gate 0)

Hi I have a calculated column that counts me no. of weekdays =(DATEDIF([Registration],[Gate 0],"D"))-INT(DATEDIF([Registration],[Gate 0],"D")/7)*2-IF((WEEKDAY([Gate 0])-WEEKDAY([...
0 votes
1 answer
13 views

Years of Service with IFBlank but what if date is in future

I have a field that calculates "Years of Service" and calculated to either TODAY for a active employee OR to the termination date if terminated.  However, on the list dashboard if the start ...
  • 5
1 vote
1 answer
8 views

Calculated column hyperlink generated not displaying text

I have a SharePoint on-premises calendar list created. need a hyperlink column in event view form to download ics file from a hyperlink. The download link gets created and works fine but i need to ...
0 votes
1 answer
15 views

Calcualted column is returning "#Name?"

I have the following formula for a single line of text Calculated column named ShowInApp: IF(OR(Status="Inactive",ISBLANK(Status)),"Hide",IF(FIND("Pending",[Category]),&...
0 votes
1 answer
22 views

IF Statements in SharePoint List

I have created a flow within Power Automate that when a Form is submitted it creates an entry into a SharePoint List. Once the entry has been approved a new entry is created in a new SharePoint List, ...
1 vote
2 answers
27 views

Adding Calculated Column to List to sum values in columns while ignoring blanks

I have a questionnaire that populates a SharePoint list. There are a number of questions that return answers as picked from a choice column. I have a calculated column that I'm trying to get to return ...
  • 13
1 vote
3 answers
29 views

Calculated column to calculate approved status workflow

How to use calculated column to calculate approved status workflow? I tried this but it doesn't work. IF([Approve status]="Pendding", 1, 0)
  • 23
1 vote
1 answer
19 views

Create column that is filled automatically (depending on another columns)

I am working with a SharePoint list that contains information about new employees. One column represents the StartDate, another column the EndDate (according the contract). In my company we have two ...
  • 13
1 vote
1 answer
32 views

List Validation with IF & LEN

SharePoint Guru's please guide me to complete List request. Requirements: I have been creating a List for doing User Audit Manager has to select the Choice either Approved or Rejected under Access ...
0 votes
1 answer
20 views

SharePoint List Validation Settings gives me Syntax error

=IF([Urgency Level] = "XL", IF(ISBLANK([Date and Time of Production Stop just in case of XL]),false,true),true) I get a syntax error message with this formula. It tells me either the ...
  • 3
0 votes
1 answer
27 views

Need help with another sharepoint validation formula

I am trying to validate the Ticket Number field for certain task types and i am trying to validate the Manager email field for certain task types. My fields are like this: Task Type (Radio button ...
1 vote
1 answer
18 views

Average Ignoring Blank Columns

Really struggling with formula on a calculated column on my SharePoint list for some reason! I am trying to get the average of 3 columns sometimes one will be blank some times there will be no blanks. ...
  • 13
1 vote
1 answer
28 views

calculate the sum of months from a fiscal year horizontally from one list to a summary list

List 1- Food Jan Feb Mar Total 1000 1000 1000 3000 sum sum sum sum This list is a category and lists 2-Clothes, 3-Water, 4-Internet, 5-Misc are the same I need the sum of the columns of this list ...
0 votes
1 answer
22 views

Calculated column not working properly

I have a calculated column which is not working as intended. There is an 'if' condition which checks the value from a date column called 'Modified' and it sets the calculated column to 90 days after ...
  • 103
2 votes
1 answer
23 views

Need help with column validation on a single line of text field

I am looking to validate that my field always starts with the following text before allowing it to be saved "inc", "sctask", "prb", "chg", or "ritm". ...
1 vote
1 answer
19 views

Need help with my SharePoint list validation formula. I cant seem to figure out how to combine the below statements. Any help is appreciated!

I have a SharePoint list with the fields listed in bold at the bottom. I currently am using the below formula to validate that when options 1 and 3 are selected, I am requiring ticket number is not ...
1 vote
1 answer
18 views

CALCULATED column issue

Scenario: Need to get difference between two dates (Start Date, End Date) in months, and if End Date is blank, then display "Open". I am trying: =IF(AND(ISBLANK[End Date], " ", (...
0 votes
0 answers
22 views

calculate difference between two dates in sharepoint, show days, month, years

How to convert this formula from excel to use in SharePoint: to show age in day, month and year? Current formula: =IF(DATEDIF(TODAY(),[birth],"y")=0,"",DATEDIF(TODAY(),[birth],&...
1 vote
1 answer
32 views

Using nested IF and IF(AND) statements to display different info in calculated columns

I'm trying to display some text in a calculated column depending on whether or not the input of the other columns is blank. The columns are single-line text: [Creator] and [Organisation]. The idea is ...
  • 13
0 votes
0 answers
55 views

How to create a calculated date column for recurring dates?

I have created a SharePoint list which calculates a date using two fields. The three fields are Start date (Date field) Recurrence (Choice: Month, Year, 3 years) Next recurrence (Calculated column ...
  • 67
1 vote
1 answer
34 views

Calculated column to show negative number as zero

I have the below formula in a calculated column, which in some instances will return the number as a negative number (eg. -1234) how do get the formula to show the negative number as 0. =IF(ISBLANK([...
0 votes
0 answers
13 views

SharePoint 2016 Calendar/Image in Month View Title

I am trying to show picture (based on condition) in Month View. I've managed to manipulate HTML Markup Functionality and now I am able to show picture in Calculated column but in "All Events&...
0 votes
2 answers
40 views

Calculated column issue in Sharepoint List - Excel Formula Given

I have tried to apply the following formula in the SharePoint list but somehow it gives an error. Can the same formula be used or any changes are to be made? Please help me out. I have given the ...
1 vote
1 answer
49 views

List Validation syntax error

I have a challenge with the List Validation process for a simple form. I need to check 2 fields: If [NPC Status] is "Passed" and [NPC End Date] greater or equal 2/24/2022. =IF([NPC Status]=&...
  • 13
1 vote
1 answer
76 views

Calculated Column IF OR AND 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: = IF( OR( ...
  • 11
0 votes
1 answer
17 views

Calculated Column formula to find two values in column

I have a Single Line Text Column(Content). I would like to create a calculated column that returns "Yes" if the Content column contains either of the two words- "Urgent" or"...
  • 11
2 votes
1 answer
12 views

SharePoint Validation Settings

I have a drop down with Not Started, In Progress, Completed, No Longer Needed as different options. I want to require In Progress Comments to be filled in when In Progress is selected. When Completed ...
0 votes
0 answers
9 views

I'm trying to calculate the Hitrate percentage of a manager for each week of the month, there are months when we have 5 weeks as well

I'm trying to calculate the Hitrate percentage of a manager for each week of the month, there are months when we have 5 weeks as well. Below is the code I'm using: =IF(OR(HRW01+HRW02+HRW03+HRW04=4,...
  • 1
1 vote
1 answer
13 views

Calculated Field (Dates)

I have a vendor SharePoint list and am trying to do a calculation between two dates to let me know when the next Review Date is. All Vendors have a start date but they don't have an expiration date. ...
1 vote
1 answer
37 views

How can I use the doc ID in a calculated field

The document ID is this: EY3P5SDA5APP-512271551-6 and I would like to isolate the last digit (here 6) using a formula. I tried this formula: =RIGHT([Valeur d’ID de document],LEN([Valeur d’ID de ...
0 votes
0 answers
26 views

SPOL Calculated Column Formula Help - Working Days

I’m trying to find the solution to 2 calculated column requirements. I have searched quite extensively and have only found partial, or partially working answers. The two requirements are: Work out the ...
  • 1
0 votes
0 answers
16 views

Map excel column with complicated formula in power app table

I have an Excel column containing complicated formula (if statement, concatenate, VLOOKUP), and I need to create this column in Dataverse (solution table in Power apps). Since it's not just a ...
0 votes
0 answers
34 views

How do I create a calculated value for a column in SharePoint online

I have a list within SharePoint online. One column is for doc type (choice field), another column is expiration date (Date/time field) and third column is status column(Choice). When the document in ...
0 votes
0 answers
21 views

Work Day Calculation

I have a field which calculates the number of minutes between two different times and dates. It excludes weekends for me as well. My team is wanting to take this one step further and modify it to only ...
1 vote
1 answer
125 views

Calculate the week from a date, Jan 1st = week 1

I'm looking for a calculated column formula which will calculate 1st January 2022 as week 1. I'm in Europe, so, like most of the world, my date field 01/01/2022 = 1st January 2022. I would like 1st ...
  • 2,329
0 votes
2 answers
67 views

Calculated column status

Mind to help why this formula return error. do note StartDate and EndDate column is Date and time type while this calculated column will be single line of text IF([StartDate]> [TODAY], "...
0 votes
1 answer
45 views

Calculated column, formula to count how much time left before deadline

I have 2013 list (on premises) and I have a column "Deadline date". I need to create a calculated formula which 30, 60 and 90 days before will show such text, 30, 60 or 90 days left before ...
0 votes
1 answer
22 views

I want to look at 2 date & time fields and compare that to now to return a status

We have locations that are open or closed for the day. I want to create a list that has a status column that says if that location is open or closed based on two other date and time fields. Example 1: ...
0 votes
1 answer
60 views

Date and Time Calculation excluding weekends

I want to figure out the amount of time between Quote Start Date and Quote Complete Time in minutes and exclude weekends. I have tried several examples I found online but I always get a syntax error. ...
0 votes
1 answer
64 views

SharePoint List - Advanced Formula - 3 Criteria

I need to use a SharePoint list instead of an excel and I can't find a way to write the following formula. In the excel I use VBA. The case is: Each user will import the following data: Column A: ...
0 votes
1 answer
70 views

SharePoint Online calculated column formula error

I would like to create a simple calculated field, that returns a text if a value is greater than another. Column [Bruttó összeg] is number type. I just copied the formula from the official Microsoft ...
1 vote
1 answer
182 views

Column validation of sharepoint list

I am trying to create a column validation based on the other column's output and I constantly get the error. I have 2 fields: Testing - choice column with the value "Yes" or null. Test date ...
  • 21
0 votes
0 answers
17 views

Calculate Business Days which are Monday - Thursday in this case

This works perfect for standard workdays but wonders where I can update for just M-Thur only IF(ISERROR(DATEDIF([StartDate],[EndDate],”d”)),””,(DATEDIF([StartDate],[EndDate],”d”))+1-INT(DATEDIF([...
0 votes
2 answers
60 views

Using calculated value columns using date

I have a SharePoint list that has the following columns: I'm having a hard time making this. I want to make the Status column a calculated value dependent on departure and return. I want to show if ...
  • 1
0 votes
1 answer
29 views

More than 19 IF Statements in a Formula in a calculated column

I have the following formula in a calculated column which contains 19 IF statements. I cannot add any more but I need 6 more. Any ideas to solve this. =IF(AND(Likelihood="Rare",Consequence=&...
  • 1
0 votes
1 answer
32 views

Converting Excel formula to SharePoint Calculated column formula

I'm pretty new to SharePoint calculated formulas and am struggling to convert an Excel formula I have to a SharePoint calculated column formula. The Excel formula is =FLOOR(280-(J5-TODAY()),7)/7&&...
1 vote
2 answers
86 views

SharePoint List calculated field syntax

I am unable to get this SIMPLE calculated field to work. Note that I am not a programmer and do not use codes a lot. So please help in details. I have a SharePoint list where I want to get a simple ...
1 vote
1 answer
46 views

Calculated Column to show only Month and Year from formula results?

As is, the formula below works perfect for my project. However, I would like to spice it up by having the results just display the Month and the Year of the "Next Test Date". Also, is there ...
1 vote
1 answer
30 views

Returning a value based on date of return

Please I need help. I have a column called "Date_Of_Return". I want to create a calculated field to return "SMP" if the arrival date is greater than "01-11-2021" and ...
  • 21
1 vote
1 answer
39 views

SharePoint List - Column Validation

I want to write 2 formula to validate below conditions: I have 3 columns in SharePoint list: Date of Booster (Date field) Is resident in Hospice? (Yes/No Field) Date Admission at Hospice (Date Field) ...

1
2 3 4 5
15