Questions tagged [formula]
The formula tag has no usage guidance.
10
questions
1
vote
2answers
51 views
Remove all commas from single line of text field
Trying to remove all commas from a single line of text SharePoint Online field entries.
Any ideas on how to achieve that, any formatting formulas, or JSON?
Thank you in advance!
0
votes
2answers
27 views
How to add two different formulas in column validation SharePoint
Need to restrict the user from entering special characters and to make the input length equals to 24 i.e the user can enter only alphabets and numbers of length 24.
0
votes
2answers
40 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
47 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
67 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
10 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
96 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
122 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
61 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
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] ...
