Questions tagged [formula]
The formula tag has no usage guidance.
0
votes
2answers
33 views
Date validation to specific year for list Column in view
I've got a date column in a view and I'm using a validation formula:
=IF(TEXT([Data documento],"yyyy")="2018",TRUE,FALSE)
So that users can only insert date within the year 2018.
I always get an ...
0
votes
2answers
41 views
List Validation settings Error in Formula
I am trying make the Billing Status field required only when the A La Carte field is checked (true) or not blank (otherwise it is not required). I don't know whether to set this up in infopath or on ...
0
votes
2answers
26 views
Attempting to get a Calculated Column to output Yes/No (Formula)
I am trying to make a calculated column produce a Yes/No when:
IF([Reminder Date]= [Today], “Yes”)
and
IF([Reminder Date] does not equal [Today], “No”)
What is the correct formula?
0
votes
0answers
7 views
Date and Time formulas
If you put in a formula for a date and time to calculate a difference, but only one of the fields has an answer - it returns a huge number rather than 0 - so when needing to tally average difference ...
6
votes
0answers
91 views
Formula in spreadsheet being converted to a custom list
I am currently trying to take an existing spreadsheet and replicate this as a SharePoint list.
The spreadsheet contains the following columns:
Received - This will be a number column with 0 decimal ...
1
vote
1answer
60 views
InfoPath If Statement
I need to add an InfoPath formula such as the following:
if(Unit = "Percent"){
Numerator / Denominator *100}
Else{Numerator}
I know the formating something like (TrueResult | ElseResult) [(...
0
votes
1answer
34 views
Conditional Required Field in SharePoint List (Exact text match)
I need to write a rule to conditionally require data in a field based on the values in two other columns:
Status Column: Values include "Active" or "Inactive"
Type Column: Values include "Full Time",...
0
votes
1answer
25 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] ...
