Questions tagged [calculatedfield]

The tag has no usage guidance.

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

If and else if in sharepoint list calculated column giving syntax error

I have two date fields date1, date2 and stores in column name result . I need the difference of the two dates to be calculated and store no of days in the result. Problem here is with two cases: ...
0
votes
1answer
31 views

Calculated Field Syntax Error - Matrix Output

I'm quite new to this, could anyone point out why my calculated field isn't working Im trying to use a matrix to output a value of critical, high, medium or low The field Im using is ImpUrg_Total, ...
0
votes
0answers
17 views

Link to calculated field

I'm looking to add a link to an image that when clicked, would initiate an Outlook email to the user's supervisor (information is listed in the user profile). Is this possible? Working in SharePoint ...
0
votes
0answers
59 views

Error: Binding a non-repeating control to a repeating field or group is not supported in SharePoint list forms

I am creating a sign-up list for a company potluck, and I want to show the number of certain dish types that have already been signed up for. Details: I have two lists: Potluck Signup List, and Dish ...
1
vote
1answer
23 views

How do I insert “Created by” into a concatenate formula?

To have month view in a SharePoint calendar which displays the value of more than one field. I would like to combine the Title with the user's name using calculated column type. But Createdby can't ...
2
votes
1answer
136 views

Help with Traffic Light SharePoint Calculated Formula

I am wanting to create a column called "Traffic Light" on an existing SharePoint Library. Column Name = Traffic Light Data Type = Single line of text Formula: ="<DIV style='font-weight:bold; ...
1
vote
2answers
33 views

How to sort column fields and get its total

Dear SharePoint Experts, I would like to ask for tech support regarding on the screenshot that I attached. As you can see from the image, I have a My Requests, All Items, My Balance views, in My ...
0
votes
1answer
42 views

Calculated column based on value of other column

I have two fields in a SharePoint list - 1. Archive Status (Choice field which are Active, Archived and Cancelled) and 2. Archived Date (Date Field). Is it possible to automatically calculate the ...
0
votes
0answers
15 views

Workflow reducing balance

I have workflow that follows a vacation request form, once approved it reduces the DaysUsed by 1 because I can do that. However, I want to reduce the DaysUsed by the number of days requested in the ...
0
votes
1answer
17 views

Difference between dates in two last items form the same order

I tried to look for the answer in the forum and google, but with no success. I have a list: let's say: 'Site ID','Date requested' 11111, 2019-03-05 11110, 2019-03-15 11111, 2019-05-01 I want to ...
0
votes
1answer
27 views

Calculating a due date based off two columns

I have an [assessment] and a [reassessment] column and I want to calculate the new reassessment due date. If the [assessment] date is blank then I want the result to be blank. If the [assessment] ...
0
votes
0answers
36 views

Multiple choice lookup field does not render on edit form

I have, for the last few years, used a field called "Enabled" and a calculated field which returns the value of the Title field if Enabled is true. If Enabled is false, it returns an empty string ("")....
0
votes
2answers
61 views

DATEDIFF() Not Calculating Number of Years Correctly

Using 10/1/2008 as the "HireDate" field, the calculated "Number of Years" returns 9 years when it should clearly be 10 years. Using 8/1/1988 as the "HireDate" field, the calculated "Number of ...
1
vote
1answer
34 views

Jquery to display days since modified in list view

I have found plenty of examples on using a calculated column to display days since created. That was a simple excel formula in a calculated column. I need to display days since modified that updates ...
1
vote
1answer
106 views

SharePoint Online- Column Calculations Getting Total Items Missing

This is for SharePoint Online Having trouble getting column item count of empty entries. Originally I was attempting to find the total number of items missing in a column. example: Column A has ...
0
votes
1answer
24 views

Simple Site Column Calculation

I have a calculated Site Column which I want to be some text "PRJ" plus a number from another site column (type number - nothing after the '.') (PRJ-ID - value 00001) in the content type. I try and ...