Questions tagged [formula]
The formula tag has no usage guidance.
37
questions
0
votes
1answer
17 views
Fomular to automate project final status
Please i need help. I need a formula on share-point online list. I have 3 columns namely: Child care status, Education status, Micro business status. Each of the columns above have (Completed, ...
0
votes
1answer
20 views
Sharepoint List Column Calculation Nested Formula Failing
I have a column in my Sharepoint list that for some reason doesn't seem to be calculating properly, it does however work in Excel. I am trying to get the result to put a zero if the choice column is &...
0
votes
1answer
27 views
Help with SharePoint List
I'm stuck here with this SharePoint List columns formula.
Probably there is a easier way of doing this.
I have a column with two choices, one for phone and other for laptop.
I created the columns but ...
0
votes
1answer
15 views
Category and Subcategory formula in Sharepoint list and no coding
I am trying to create a calculated formula in Sharepoint List.
I like to create 2 columns(continent and country) with default country.
E.g. Continents are North America and South America. When you ...
1
vote
1answer
19 views
Using AND function in SharePoint
I am trying to create relatively simple conditional column formatting in a SharePoint Online list.
This works (the conditions 1==1 and 2==2 are placeholders to simplify the example here):
{
"$...
0
votes
1answer
32 views
Column Validation/Validation Settings, How can I add a formula where if one answers YES to one column it will require them to fill out certain columns
I have a sharepoint list where I have a series of questions.
The first question in the series is a YES/NO question, and it states if the answer is no, there is no need to answer the next few ...
0
votes
0answers
27 views
Simple Scoring Setup for List
I am trying to set up a list with a scoring system that I currently use in Excel. I use the Excel sheet as a form with a series of yes/no questions. 100 points is the maximum amount and each question ...
0
votes
0answers
15 views
Creating a sequential number on a SP online list
I thought this would a fairly straight forward problem to solve. My client needs a unique identify number for a list item and it has to be seven digits long and sequential. I thought there would be a ...
1
vote
1answer
13 views
How do I dynamically choose the view form
I've got a SharePoint Online list that I want to use as a ticketing system. Users can submit a few different types of tickets. The various ticket types contain different fields, validation, etc. All ...
0
votes
0answers
12 views
Switch function in SP calculated field? [duplicate]
I've got a SP drop down column which contains options like:
Doesn't align to current priorities
Somewhat aligns to current priorities
Aligns strongly with current priorities
I want to assign all of ...
1
vote
1answer
38 views
Formula for swapping the choice in a drop down with a numerical value
I've got a SP drop down column which contains options like:
Doesn't align to current priorities
Somewhat aligns to current priorities
Aligns strongly with current priorities
I want to assign all of ...
0
votes
2answers
34 views
Format numberfield to currency
I have a SharePoint list and created a powerapp.
In the SharePoint list there is a field Kosten and the value 20 in powerapps looks like 20.0000000000000.
How can I change this to € 20,00 ?
1
vote
2answers
33 views
How to enforce to input value from another column?
I've created 3 columns:
Choice:
Banana
Apple
Orange
2.Start date
3.End date
If you select "banana", then he/she must input value for "start date" and "end date".
I tried to input the formula ...
3
votes
2answers
131 views
Percentage formula showing extra numbers
I'm trying to get a SharePoint formula to show a percentage of time remaining on a contract. I'm nearly there but it's showing a lot of numbers to the right of the decimal point. I've tried a few ...
2
votes
1answer
27 views
Showing the time remaining between two Date columns as a perentage
I've got two columns 'Contract Commencement Date' and 'Contract End Date' and I'm trying to show the time remaining as a percentage in a third column.
Using Flow I've got a field to show todays date,...
1
vote
1answer
22 views
SharePoint list validation formula
I need help with the following: I have 2 columns in a list and when "Yes" is selected in column 1, then "Yes" must be selected in column 2 also
What I need is:
If [column 1]="Yes", then [column 2] ...
1
vote
0answers
20 views
I am trying to make a value limited RSVP System
I have been tasked with creating a list in SharePoint to let users pick one of three training sessions. Each training session must be limited to 50 users.
I've been leaning towards a list with a ...
0
votes
2answers
108 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
31 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
25 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
91 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
32 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
120 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
220 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
353 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
114 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
19 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
26 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
407 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
39 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
93 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
133 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
356 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?
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
938 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
612 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
30 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] ...
