Questions tagged [calculated-column-formula]

Question related to the Calculated Column

Filter by
Sorted by
Tagged with
0
votes
2answers
18 views

Calculated Column Question Blank Dates

I have been stumped on this particular task for weeks. Any help would be greatly appreciated. I have three columns I am working with: Date Admitted to Hospital (date column), Date Discharged (date ...
1
vote
1answer
41 views

Mulitple IF Statements based on other criteria

I have this and it works on its own: =IF(ISBLANK([Basic Finish]),"Past Due",IF([FCM 4 Expected Date]>[Basic Finish],"On Time",TEXT([FCM 4 Expected Date]-[Basic Finish],"h:m:...
1
vote
3answers
25 views

Blank a column if a condition is met

I have a established a custom list with 5 columns for testing. Title column Date columns (Date1 & Date2) Calculated column to count days between the 2 dates (Total) Calculated column to count how ...
0
votes
1answer
20 views

Calculated Column to Get Totals & Percentages

So I have columns set up like so: Entity Region Quarters Year Month #ofOps #ofMisops %ofMisops Company A East Q1 2020 Jan 1 1 100% Company A ...
1
vote
1answer
23 views

Nesting IF Statements in SharePoint Calculated Column

Uhh!. I have 3 statements that individually return my values. Now, I need to put these together into one formula. Here are my statements that need combined into one calculated column. Thank you. 1st ...
0
votes
1answer
31 views

How to get a particular value in the calculated column

I am trying to implement the following code in a calculated column named [Valid] in a document library in modern SharePoint online. =IF([Valid Until]-TODAY()>=0,"Valid","Expired"...
0
votes
1answer
18 views

Priority Due Date column sharepoint online

I need to setup a Due Date calculated column on an SPO list and whilst I've managed to work out the formula for days, I cant quite work out hours?! I have SLA priorities on my list as per the below: 5=...
0
votes
1answer
39 views

Calculated Column with TODAY() issue

Using the following: "If Authorization Date is null, calculate the difference between Receive Date and today; If Authorization Date is not null, calculate the difference between Receive Date and ...
0
votes
1answer
37 views

My Sharepoint formula not working

=IF([Sett. Start]<=Today,"Visit Due",IF(ISBLANK([Visit Notification No.]),"Visit Not Due","Visit Done")) I am using above formula in SharePoint List but it is working ...
0
votes
1answer
18 views

Fomular to automate project final status

Please i need help. I need a formula on share-point online list. I have 3 columns namely: Child care status, Education status, Micro business status. Each of the columns above have (Completed, ...
0
votes
1answer
31 views

Column Validation with If Formula

Need your assistance in writing formula. I have SharePoint List with a choice field Named as "Status" with "Active" and "InActive" as choices. By default this is set to ...
0
votes
3answers
48 views

=IF(ISBLANK([Last Update]),“”,TEXT(NOW(),“dd/mm/yyyy”)-[Last Update]) is retruning negative numbers

I have the following formula inside a calculated column:- =IF(ISBLANK([Last Update]),"",TEXT(NOW(),"dd/mm/yyyy")-[Last Update]) but today is 27/08/2020, and on some cases where ...
1
vote
2answers
29 views

Multiplying hours/minutes in a calculated column

I am trying to use calculated columns to sum the difference between two times then multiply that result by a number. The SharePoint list looks like this: The "Start Time" and "End Time&...
1
vote
2answers
22 views

Sharepoint Online Modern = Right formula crashes

Using Sharepoint Online Modern experience. I am trying to use the right formula in a column with a calculated value and get an Sharepoint error. I have a column named LOCATION and has a string value ...
0
votes
1answer
35 views

Minus 5 hours 30 minutes from a date

I have a column of type as date and time. I want to minus 5 hours 30 minutes to produce a new time in a new column - Please advise?
0
votes
1answer
17 views

Calcualted column formual “=TEXT(NOW(),”mm/dd/yyyy“)-[Last Update]” will show 44,055 if the [Last Update] column is empty

I am working on an online SharePoint site, and I created a calculated column with the following formula:- =TEXT(NOW(),"mm/dd/yyyy")-[Last Update] now the formula is working well if the [...
1
vote
2answers
23 views

How do I create a calculated column that displays Yes or No if ANY other columns in the row have the value “Yes”?

I have a series of 3 Choice columns that are populated by a MS Form to be either "Yes" or "No". I am wanting Column4 to show Yes if ANY of the columns 1 2 or 3 contain the value &...
1
vote
1answer
13 views

How do I write validation statement to require a day of the week?

I have a field in a custom list called "WeekOf". I have a default statement that populates the date as the following Monday, but some people are entering for future weeks and then add a ...
1
vote
2answers
21 views

Calculated column formula not working when referring to a Yes/No type column?

I am working on a SharePoint list validation to automate some process. I have Column A which is a Yes/No type column and I have Column B which is a calculated column that will take input from column A....
0
votes
5answers
38 views

Sharepoint Calculated Compliance Column

I have an SharePoint list with columns: Title (Single Line Text column) DteofAwrd and CurrentDte (both date columns) ComplianceStatus (calculated column) I am using the below to determine compliance ...
0
votes
2answers
20 views

Sharepoint list have german date convert into Monthnumber

I have a German client sahrepoint list and I want to convert month from date column in number. Like Month and Year in German: Want to Extract Month and year in separate column for further calculation ...
1
vote
1answer
27 views

Calculated Date Difference Question

Before submitting this question, I've tried researching this in the forums and have attempted multiple variations of suggested formulas with no success. So apologies in advance for asking what seems ...
0
votes
1answer
26 views

Nested IF Statement in SP List Calculated Column

I need to create a Nested If statement based on several columns. Column 1. CurrentDate (Date) Column 2. DteofCQ (Date) Column 3. CQTitle (Text) Column 4. ComplianceStatus (Calculated) There are 8 ...
0
votes
0answers
17 views

Difference calculation in SharePoint list - Calculated column with condition

I am working on a leave approval request that calculates company offs too. As per my logic, the first comp off should get subtracted from 12 which is the total number of comp off for this year going ...
1
vote
1answer
43 views

Calculated Column - Days Difference - Syntax Error

I have a SharePoint List and I'd like to have a column to calculate the days it take to solve a ticket (Solution date - Submission Date). I tried to create a calculated column, by using a formula = ...
1
vote
2answers
23 views

Multiple IFS in Sharepoiint Calculated columns

I am trying to write a formula in a calculated column that would populate shift hours base on shift name. The Shift title column is names "ERSShift". The different shifts available are "...
0
votes
0answers
15 views

Column Default Value Based on Root URL

I have a tab in an MS Teams team where users can view our upcoming corporate training sessions (i.e. modern Events). In each event description, I am putting a link to a sign up form. The sign up form ...
1
vote
1answer
30 views

Calculated column in SharePoint list - Conditional formula for finding difference

I am working on creating a leave tracker list. For that, I have added a column for Leave Type with 4 choices with 1 choice being company off. I want to add another column that says => Comp offs ...
1
vote
2answers
31 views

Adding days on calculated column from monday to friday

I need to add a calculated column in SharePoint where I have to add +1 day from Monday to Thursday and +3 on Friday but I don't know how to do it. I did some tests with WEEKDAY without success.
0
votes
1answer
34 views

Validation setting for Date Sharepoint

I want to apply validation setting so that my "ActionDate" should be always greater than 2 year and 6 month. I can able to set greater then today but how to set it should greater then 2 year ...
1
vote
1answer
21 views

check tow fields values in sharepoint validation settings

I have a form to create a task and the user can edit it after manager approve it, I don't want to allow the user to submit after approval if field [Task Status]="Waiting on someone else" or ...
2
votes
2answers
64 views

Calculated Column: Prevent date from changing - SharePoint 2013 online

Need some help please - currently working on SharePoint 2013 online. I have a choice column (drop down) called 'Stage'. In 'Stage', I have 3 choices; Start Pause End I also have 3 calculated columns ...
0
votes
0answers
18 views

Start Time (EventDate) when used in calculated field, showing minus 1 day if AllDay is selected

I am working on a SharePoint 2010 Calendar. Creating a column with a calculated field type. Using =Text([Start Date]), "ddd, dd, mmm") and for some reason, When I am selecting the Event as ...
0
votes
1answer
29 views

Validate Due Date less than 12 months

I have a field named "Due Date" and I am trying to add validation so users cannot enter a date more than 12 months from today (current date). This is SP2010. I've tried this formula in the ...
1
vote
1answer
20 views

Sharepoint 2013 List validation - two fields contain text

Pardon this newbie question on SharePoint list validation, I have been researching this for days SharePoint 2013 SharePoint LIST validation since you cannot compare two fields in FIELD validation Two ...
0
votes
1answer
26 views

Add a calculated column with if statements

New in this forum. And I have a quick question: I have a choice column with this values: Kg Lb Ton And I would like to add a column that multiplies if I choose Kg or Lb or Ton and convert ...
0
votes
1answer
20 views

SharePoint time difference in minutes - wrong result

I created a simple SharePoint list and I am having problem with a calculated field. I have a "Duration" field that calculates the minutes between the start and end date/time columns, using the formula:...
1
vote
1answer
22 views

Issues with calculated field syntax

Our school district uses O365 Sharepoint in the cloud. I've been tasked with creating a calendar in Sharepoint for all users for conference rooms reservations. I have NO experience with Sharepoint. ...
0
votes
1answer
25 views

Sharepoint list with calculated column - formula IF does not work

Working on a SharePoint list with a calculated column with a date, which I want to make dependent on priority (column is called Prioriteit), and date of creation (Datum melding). I made this formula ...
1
vote
1answer
46 views

Validate a column only if another column is not blank - Excel Formula not working

I need to add a column validation to my list. The requirement for the validation is that the column [Body] cant be empty if the column [Status] is one of this statuses: "1-Cancelled" or "2-Awaiting ...
1
vote
2answers
20 views

Using DATEIF only if another column returns 2 out of the 3 column entries

I'm attempting to calculate the difference in dates (the current date & Date Opened column) only if the Status? Column reads Open or Hold. I've tried: =IF(Status?,"Open" OR "Hold",(DATEDIF([Date ...
0
votes
1answer
31 views

SharePoint Calculated Column by searching another column for various strings

I am working with a SharePoint 2016 list that contains one column with names and other values. I want to use a calculated column to search that "name" column and return another value if that "name" ...
0
votes
1answer
24 views

How to calculate the difference between two data in the same list column

I want to know how to calculate the difference between two data in the same column of a list. It is useful if we are monitoring the changes (daily-monthly-etc). TX for your suggestions on how to make ...
1
vote
1answer
41 views

SharePoint List - Time Calculation

We have a change control SP list and do aging metrics on how long an item is open. I have a calculated field to calculate how long an item has been open, but am getting a negative serial date as a ...
1
vote
2answers
88 views

Calculated column from a multiple lines column

I made this formula for a calculated column that works from with single line columns, but am unable to make it work with a multiple line column. =IF(ISERROR(FIND("flight",[shipping])),"ground","...
0
votes
1answer
37 views

Sharepoint list for vacation accruals and usage

I've been trying to create a sharepoint list that displays the current available balance of an employee's vacation hours. I'm having issues creating a column that is calculated based on several other ...
0
votes
1answer
19 views

Date must be more than 2 Years from today

I have a date column in a SharePoint list. This column need to be filled with dates that 2 years forward from today or more. How can I write the validation formula for this? Much appreciated if ...
0
votes
1answer
23 views

Share point calculated columns with nested if statements

can anyone please help me in cracking the logic in below if statement, that i am trying to solve. Below is the logic i am trying three columns Item status, Treasury status and MD status if Treasury ...
0
votes
0answers
15 views

Creating a sequential number on a SP online list

I thought this would a fairly straight forward problem to solve. My client needs a unique identify number for a list item and it has to be seven digits long and sequential. I thought there would be a ...
1
vote
2answers
68 views

Increase number of decimal places in SharePoint calculated column while list exceeds the list view threshold

I am facing an issue while I need to increase number of decimal places of list calculative column. I need it in SharePoint online - unfortunately the list contains more than 40K records (and ...

1
2 3 4 5
12