Questions tagged [formula]
The formula tag has no usage guidance.
60
questions
1
vote
1answer
16 views
IF statement in Dropdown
I'm trying to fill the blank label with a phrase when the dropdown is equal to SI, but it doesn't work and I don't understand why?
I put If(Dropdown1.SelectedText="SI";"¿Desde cuándo se ...
0
votes
1answer
16 views
If Statment ( [DateTime in a Sharepoint Column] = Now (), Yes,No )
Curious to know if this is possible, i wish to create an if statment in a sharepoint calculated column where if the date in that row is equal to the time now than mark the column as yes.
The datetime ...
0
votes
0answers
6 views
Search doesn't work in Browser Gallery
SortByColumns(Filter(Search(AddColumns(Journals,"FlatClientName", Text('Client Name'.Value),"FlatTrainerName", Text(Trainer.DisplayName)),TextSearchBox1.Text, "FlatClientName&...
0
votes
0answers
21 views
Excel is reference by the Sharepoint Site name instead of Site URL
Recently migrated files into SharePoint Online via ShareGate tool.
There is an excel, which has many formula referencing to different excels. All hosted in same site (but different libraries) in ...
1
vote
1answer
37 views
Check if a time is between two other times including minutes
I have a PowerApps form which contains an adjustable "Submission Date" field. Here is a screenshot to show what I mean:
I am trying to come up with a formula for a calculated column in ...
0
votes
1answer
17 views
Power app formula
I am trying to disable the button, if two text fields are not completed.
I am using formula:
If( IsBlank(TextInput7.Text) or IsBlank(TextInput1_4.Text) , Disabled, Edit)
This is giving me error. Any ...
0
votes
1answer
40 views
Power apps visible text
I'd like to make text disappear when dropdown selection is not equal to "Please Select".
Using formula:
IsBlank(if(Dropdown1_1.Selected.Site <> "Please Select"))
This is ...
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
329 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
142 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
139 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
45 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
17 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
127 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
35 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
703 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
33 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
68 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
85 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
1k 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
150 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
31 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
39 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
39 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
329 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
43 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
25 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
43 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
65 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
37 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
225 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
35 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
38 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
353 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
79 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
40 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
143 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
127 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
249 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
465 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
672 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
446 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 ...
