Questions tagged [calculatedfield]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
2answers
25 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
25 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
14 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
35 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
52 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
29 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
66 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 ...