2022 Developer Survey is open! Take survey.

Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
1 vote
1 answer
20 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( ...
user avatar
0 votes
1 answer
9 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"...
user avatar
  • 11
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,...
user avatar
  • 1
1 vote
1 answer
9 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. ...
user avatar
1 vote
1 answer
27 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 ...
user avatar
0 votes
0 answers
22 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 ...
user avatar
  • 1
0 votes
0 answers
14 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 ...
user avatar
0 votes
0 answers
29 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 ...
user avatar
0 votes
0 answers
19 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 ...
user avatar
1 vote
1 answer
49 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 ...
user avatar
  • 2,319
0 votes
2 answers
52 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], "...
user avatar
0 votes
1 answer
27 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 ...
user avatar
0 votes
1 answer
20 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: ...
user avatar
0 votes
1 answer
28 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. ...
user avatar
0 votes
1 answer
61 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: ...
user avatar
0 votes
1 answer
24 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 ...
user avatar
1 vote
1 answer
80 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 ...
user avatar
  • 21
0 votes
0 answers
15 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([...
user avatar
0 votes
2 answers
48 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 ...
user avatar
  • 1
0 votes
1 answer
21 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=&...
user avatar
  • 1
0 votes
1 answer
23 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&&...
user avatar
1 vote
2 answers
49 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 ...
user avatar
1 vote
1 answer
24 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 ...
user avatar
1 vote
1 answer
26 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 ...
user avatar
  • 21
1 vote
1 answer
28 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) ...
user avatar
2 votes
2 answers
198 views

How to get the change date for a specific column based on its value

I'm new to SharePoint and I'm not sure if the tool can help me with this issue: I have a list with several items to organize activities/projects, as illustrated in the figure. The "Status" ...
user avatar
1 vote
3 answers
148 views

Column for SharePoint list which gives a current numeric date value that updates each day

I was told that you can't do this with a Calculated Column (is this true? sounds bizarre!). The closest I've found is a JSON column format (below) which sets an integer value. However I can't ...
user avatar
0 votes
0 answers
34 views

Como obter a data de alteração de uma coluna específica baseado no valor

Olá! Sou iniciante no mundo do Sharepoint e estou na dúvida se a ferramenta pode me ajudar na seguinte questão: Tenho uma lista com diversos itens para organizar atividades/projetos, como está ...
user avatar
1 vote
1 answer
32 views

SharePoint 2013 Mandatory Column when Based on drop down on another column

I have a SharePoint 2013 list where I need to log Issues. One of my column is labelled "Issue Status". Generally, I have REQUIRED field populated when the form is filed out and the "...
user avatar
  • 21
0 votes
1 answer
25 views

SharePoint list column IF statement

I have run out of IF multiple statement within SharePoint list calculated column, I still have more sites to add. I'm looking into a different way to build IF statement to fit all my sites (30 in ...
user avatar
1 vote
1 answer
33 views

Calculated column formula help

I have a request to generate a tracker number when a new item is created to a list based on the below logic: The number format is "TN" + CurrentDate(ddMonYY format) + Counter. eg: ...
user avatar
  • 25
0 votes
2 answers
32 views

SP list Calculated column

Trying to do calculated column where if the column text length is equal to 176 characters column returns 1, if not 0. Using this formula: =LEN([AZDP]=176, "1", "0") This is ...
user avatar
1 vote
2 answers
525 views

SharePoint Online List - days between two date columns

I've got a very simple formula to calculate the number of days between two dates which works, with one exception. Formula: =IF(ISBLANK([Completed Date]),"TBC",[Completed Date]-[Created Date])...
user avatar
0 votes
1 answer
12 views

SP list calculated field

Trying to make SP List calculated field for three sites. Each site has two conditions. Using statement: IF(AND([Site_induction]= "Chester TCC" , [Speed_limit]= "5mph"), "1&...
user avatar
1 vote
1 answer
39 views

List validation if then syntax

I am trying to use list validation to enforce that the value in the Category choice column is compatible with a value in the Activity choice column (1:1) If [Activity] = "Walking"; [Category]...
user avatar
  • 13
1 vote
1 answer
168 views

ID column does not work with concatenate formula in SharePoint list

I am trying to create simple unique ID for my SharePoint List. All I need to say is ABC-001, ABC-002 ETC. I am using formula =concatenate("ABC-", ID). It works if I refresh the formula every ...
user avatar
  • 21
0 votes
1 answer
88 views

Calculate the difference between current day and date column in years

I have a column StartDate and I want to calculate the time difference in years from that date to the current day. For example: My start date of work is 4/19/2016, it will be 5 years until 4/19/2022 ...
user avatar
  • 131
0 votes
2 answers
119 views

Calculated column difference between two dates considering Today

I have a calculated column to determine the number of days between Introduction call date and Today's date. It works fine as long as the introduction call date is less or equal to Today's date but ...
user avatar
1 vote
1 answer
11 views

Can I overload a URL to return multiple subfolders in a calculated column?

I have two images that are both located in my site assets folder and I want to show the two images based on when a source column returns "yes" or "no". I have a wrapped around a ...
user avatar
0 votes
1 answer
27 views

What is the maximum syntax formulas that I can use in calculated column on my Sharepoint list?

I have created 20 syntax formulas (IF(AND([Job Group]=) based upon two other columns on my calculated column field, but I seemed to have reached a maximum limit. I cannot load my 21st syntax formula ...
user avatar
0 votes
1 answer
18 views

If Statment ( [DateTime in a Sharepoint Column] = Now (), Yes,No )

Curious to know if this is possible, i wish to create an if statment in a sharepoint calculated column where if the date in that row is equal to the time now than mark the column as yes. The datetime ...
user avatar
1 vote
1 answer
68 views

Calculated Column based on the other column which is of type choice in SharePoint list

I am very new to the whole SharePoint and excel formulas and I am in the process of learning. I have a list in SharePoint in which I have multiple columns. I want to create a calculated column based ...
user avatar
1 vote
1 answer
143 views

Calculated Column Based off of a Date & Time Field

I have a field called "Onboarding Date" which is a Date & Time field. I want to create a new field called "RetentionDate" which will be a date 1 year later than the users input ...
user avatar
  • 131
1 vote
2 answers
94 views

(SharePoint) Generating unique numerical ID number using info from other columns

I'm fairly new to building SharePoint sites so bear with me. I am trying to use a calculated value in the default SharePoint ID column and was wondering if it would be possible to generate a unique ID ...
user avatar
0 votes
1 answer
43 views

DATEDIF function returning wrong number of days

I am not able to get the number of days between start and end dates. I am using DATEDIF(Start_date,End_date,"D") which seems correct as per articles https://support.office.com/en-US/client/...
user avatar
  • 107
1 vote
1 answer
146 views

SharePoint calculated column based on other 2 columns

I am struggling writing the formula for SharePoint calculated column. I have 3 SharePoint Columns: [Vaccination date]; [Infected] - Yes/No choice; [No testing is not needed (date)] In column [No ...
user avatar
  • 21
0 votes
0 answers
27 views

Calculated Column in Infopath

I have the below formula that works good in SharePoint form but not in InfoPath form. =if(AND(field1="", field2=""),"Not-Required","Required") The above ...
user avatar
1 vote
1 answer
22 views

Help with If/And

Running SP19 On Prem. Have a list with a column looking at type category with three options, and a completed column. I am looking at a calculated field/column in the list to filter a view with. 1st ...
user avatar
  • 13
0 votes
1 answer
31 views

SharePoint list calculated column formula

Is it possible to make a SharePoint list calculated column so that if value equals to Italy it returns '1', otherwise '0'. I am using: =IF([Question 1]= "Italy" , "1", "0"...
user avatar
1 vote
2 answers
74 views

Multiple IFs and ORs

I'm new to SharePoint lists and prefer not to work with them, but my employer has decided to utilize it. The process/formula I have in excel works, but not in SharePoint lists. We need a Calculated ...
user avatar

1
2 3 4 5
14