Questions tagged [formula]

The tag has no usage guidance.

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

Problems on RIGHT function on Sharepoint

I have a calculated field which is filled in automatically thanks to a simple formula: =(X*X*Z/162-Y*Y*Z/162)*X This generate a number like: 1.637.037 I have a problem on adding RIGHT function to ...
1
vote
1answer
22 views

Validation on column between 2 values

I am using SharePoint 2016. In a list, I created a column hostname of type single line of text. I would like to limit the values between r000xxx and r399xxx where (x= any letter). What's the right ...
2
votes
2answers
14 views

Sharepoint list validation syntax question?

I'm trying to get this SharePoint list validation formula to work. I ultimately want to make sure the date value in my [Date of Appointment] column is greater than the date value in my [Date Followed-...
2
votes
2answers
29 views

SPO Calculate the difference between two dates

I am trying to create a calculated column which shows the number of days' difference between two columns which have dates in them. I understand that I can get this with the following formula: =...
0
votes
1answer
27 views

Formula IF time between ranges (Calculated column)

I have a column "SignIn" that shows the date/time of a staff sign-in. I have another column "Late Flag" that will show if they are late or not. There are sometimes multiple sign-ins/outs throughout ...
0
votes
1answer
39 views

Send email to multiple people picker selections

I have an InfoPath list form that has 2 people picker fields. I am able to send emails to both fields using this formula below: concat(substring-after(AccountId, "\"), "@XXX.com", ";", concat(...
0
votes
1answer
39 views

SP Online Flow add() syntax

New to using flows in SP Online so I'm simply trying to add two numbers in one list(parent), using flow, and place that value into another list(child). Fields are val1 and val2 and they are numeric ...
2
votes
1answer
132 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
3answers
51 views

I want to display a blank field in the calculated column if both the reference fields are blank

I want to display a blank field in the calculated column if both the reference fields are blank, but SharePoint displays the default date as 30-Dec-1899. Formula I used in Calculated column: =IF(...
0
votes
1answer
17 views

Giving one of two options

I am really new to all of this, but I'm trying to edit a column with the following: =OR(LEFT([Ticket Number],6) ="TASK00",LEN([Ticket Number])=0) where the user is required to enter their ticket ...
1
vote
1answer
18 views

Calculated Column Depending on Different Column Value

I am new to SharePoint. I am looking for a way to assign a value for a column depending on another column's value. For example, the choice column dictates "New York" the value of the calculated ...
1
vote
2answers
208 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
31 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
47 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
88 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
179 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
15 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
100 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
299 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
143 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] ...