Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [formula]

The tag has no usage guidance.

0
votes
2answers
32 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
25 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
59 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
32 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] ...