Questions tagged [formula]
The formula tag has no usage guidance.
53
questions
1
vote
1answer
13 views
How can I set a special format in a column or leave the field blank
I have a column that is called APC Standard. In this column I want to set the following format APCxxxx (APC + 4 numbers). I also want to have the possibility to leave the column blank.
I have already ...
0
votes
1answer
43 views
How to hide a SharePoint list column if its own value is empty?
Is there a way with SharePoint online lists, to hide a column if the user did not fill in a value for it? If so, how can I setup this conditional logic for the column to check against itself?
I have ...
0
votes
1answer
31 views
How to copy single list attachment (as image) into the thumbnail/image column
I have SharePoint records in a list that are dynamically created with Power Automate. Once the record is created in my SharePoint Online list, how can I say...
Once the record is created, take the ...
0
votes
2answers
36 views
Calculated field column
I am trying to compare two date columns in SharePoint. I need to update the created date field to a different date, but only on documents that have a scan date less than the created date. So I have a ...
0
votes
2answers
31 views
Power apps button & dropdown
I need to set up a dropdown selection based on a button trigger. If button not selected, dropdown must remain empty.
Could anyone assist?
Using following syntax on the dropdown:
If(button1.selected, ...
0
votes
1answer
25 views
Calculate SharePoint Column for unique expiry dates
I am building document library on SharePoint Online to store employee training certificates that can monitor their issued and expiry dates. The validity period for each certificate is different ...
0
votes
0answers
15 views
Calculated (calculation based on other columns) IF OR ISBLANK AND Sharepoint Lists error formula
Can anyone help? I can't work out why this is erroring. this section =IF(OR(ISBLANK[Tech £]),"", at the start in bold makes it error.
=IF(OR(ISBLANK([Tech £])),"",IF(AND([Tech Pay ...
0
votes
1answer
30 views
Extract the Name of the uploaded file into another columns with a flow
I want to extract the name of the file to another 6 columns.
For example, you want to put the "D" in the file name in the first column and the word "Berlin" in the second column, ...
1
vote
1answer
33 views
My Calculated Field with a nested IF(OR) statement is returning error
I am trying to input an email address into a calculated field with the following formula (I have replaced proprietary information with generic information in this formula):
=IF(OR([Customer Name]=&...
0
votes
2answers
109 views
How to launch home page on Power Apps Forms submit button Click in same tab?
I have a list and we have customized the edit form in Power Apps. We have set this forms link in Email that we send to manager when new entry is added. He must review it and change status choice to ...
0
votes
1answer
30 views
Validation for 2nd monday from today
I am new to SharePoint and I'm trying to do a validation for greater than or equal to the 2nd Monday from today.
I'm creating a work request form and I want to make sure they can't make a due date ...
1
vote
3answers
46 views
Validation IF Column
I am stuck on a validation column, I need Date Effective From mandatory if Approval Status is equal to Approved and vice versa I need Approval Status mandatory if Date Effective From is not blank.
I ...
0
votes
1answer
30 views
Assessment Calculator in Power Apps
I need to build an assessment calculator that will perform the following:
POINTS: 0.0 - 3.0
COST: $0.00 - $1000
ASSESSMENT RATING: LOW, MEDIUM, HIGH
Assessment logic:
If POINTS between 0.0 and 1.0, ...
0
votes
1answer
117 views
Multiple Or conditions with If - PowerApps
I have 3 individual checkboxes on my Power Apps form and would like to retrieve one value of the 3 checkboxes.
Currently I'm doing the below:
If('chkAll_1'.Value = true,'chkAll_1'.Text,"") ...
0
votes
1answer
91 views
Dropdown sum powerapps
I would like to make a sum of all dropdown values into a label text box.
I am using following formula, but I do not understand where am I going wrong.
Can anyone assist?
I have also added a screenshot ...
0
votes
2answers
30 views
SharePoint Validation Formula help needed
I need assistance with a validation formula for a list with 5 content types and 5 different outcome columns and I want to force the user to choose and outcome when the outcome date is chosen and vise ...
0
votes
1answer
25 views
Calculate the difference between two dates in hours and minutes
In SP online in a list, I have a formula that calculates the difference between two dates and outputs the result in Days+Hours+Min.
I was wondering if it's possible to obtain the results only in Hours ...
0
votes
1answer
20 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
22 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
28 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
16 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
30 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
198 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
35 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
20 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 ...
1
vote
1answer
41 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
46 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
36 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
184 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
29 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
33 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
22 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
263 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
55 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
35 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
111 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
70 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
195 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(...
1
vote
1answer
390 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
577 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
299 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
29 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
632 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
62 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
153 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
172 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
504 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
102 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 ...
