Skip to main content

Questions tagged [formula]

The tag has no usage guidance.

45 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
6 votes
0 answers
106 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 ...
Kirito's user avatar
  • 187
2 votes
1 answer
16 views

SharePoint Validation Settings

I have a drop down with Not Started, In Progress, Completed, No Longer Needed as different options. I want to require In Progress Comments to be filled in when In Progress is selected. When Completed ...
user103408's user avatar
2 votes
1 answer
268 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,...
Dazza's user avatar
  • 767
2 votes
2 answers
92 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-...
user87844's user avatar
1 vote
1 answer
12 views

Formula to compare two date fields in SharePoint Lists

I have two date fields, not time stamp, in SharePoint that I want to display an error if one date is less than or equal to the other date field. I'm not looking to calculate anything, just a simple ...
Jennifer A. Gonzalez's user avatar
1 vote
2 answers
36 views

Not sure I am doing this right and need help. If Column B is blank Column A should multiply by Column C. If Column B has info B need to multiply by C

Not sure I am doing this right and need help. If Column B is blank Column A should multiply by Column C. If Column B has info B need to multiply by C =IF([Column B]="IsBlank" AND, ([Column A]...
user110949's user avatar
1 vote
1 answer
42 views

Calculated Column: Nested If

I am new to SharePoint and I'm trying to enable a calculated column in a SharePoint list with the following formula but it's not working quite well. It is not throwing me any Optimize nor Test ...
Mariana's user avatar
  • 11
1 vote
2 answers
321 views

Use variable in expression:

I would like to add a dynamic variable in addDays function named Czasookres his value is equal 14 days. How can I insert this variable and is that possible ? Examples: addDays(utcNow(),Czasookres) - ...
Cutmaster's user avatar
1 vote
2 answers
41 views

Make a column display only when data is in it

I am trying to make a column display only when data is entered in it. If it has no data, then the column should not display on the page. I tried this formula, but it isn't working. I will appreciate ...
erron522's user avatar
1 vote
1 answer
321 views

Hiding the field/data card from everyone but the user who created the item

I would like to hide a data card from everyone but the user who created the item and have been using this code: If(ThisItem.'Created By'.Email = User().Email, true, false) But this doesn't seem to ...
NK711's user avatar
  • 41
1 vote
3 answers
559 views

Calculated column to calculate approved status workflow

How to use calculated column to calculate approved status workflow? I tried this but it doesn't work. IF([Approve status]="Pendding", 1, 0)
Bloom 's user avatar
  • 23
1 vote
1 answer
1k 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 ...
Franco's user avatar
  • 11
1 vote
1 answer
1k 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 ...
arbi's user avatar
  • 11
1 vote
1 answer
19 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 ...
AndiPm's user avatar
  • 11
1 vote
1 answer
41 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]=&...
Rebecca Bacila's user avatar
1 vote
1 answer
140 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] ...
Simona M's user avatar
1 vote
0 answers
24 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 ...
Harrison B's user avatar
0 votes
1 answer
20 views

How do you apply the Concatenate function in Power Apps when using the Patch function in claims?

Tried several codes but I can't get it: Patch(DUTY, Defaults(DUTY),{ OCC_Claims:{ Claims: "i:0#.f|membership|" & Lower(cmb_soconduty_login_1.Selected.Email), ...
Jorge's user avatar
  • 1
0 votes
1 answer
31 views

Power Automate Flow - Send an email if a SharePoint 'Proposal Date' Column = the current month

I have a SharePoint list with a proposal date column (SP column name is ProposalDate). I want to manually run a flow that will query the entire list, identify items with a Proposal Date this current ...
Chris's user avatar
  • 409
0 votes
0 answers
21 views

SharePoint list validation formula based on created and modified dates no longer evaluates as FALSE ever

To clarify, the formula below is for list validation and not field validation: =IF(OR(NOW()<[Created]+(1/1440),NOW()<=[Modified]+(10/86400)),TRUE,FALSE) This checks for the following conditions:...
Scott Olson's user avatar
0 votes
1 answer
27 views

SharePoint to show 'Working days left' and blank if other column is marked 'Complete'

I've been looking on this page and others can't seem to get exactly what I'm looking for, not sure if it is possible but I will ask. One column shows 'Delivery Date' so I've used the following to show ...
Adam Richardson's user avatar
0 votes
0 answers
910 views

Adding bold and underline in a Power Apps formula

I have a formula (see below) to append comments in Power Apps. It is under "default" in the card. I am struggling to get "User().FullName & " " & Now()" of the ...
Ulcsmarine001's user avatar
0 votes
0 answers
38 views

Formula Help Needed: Calculating Dates to Exclude Weekends

I am trying to set up several dates on a list in SharePoint. The dates all relate to each other, and I want to exclude weekends when calculating these dates. I have three date columns: “Request Date” -...
Sara Lons's user avatar
0 votes
2 answers
792 views

How can I write an Expression to get an Item from an Array using an Array property value?

I have this flow : Where I am building an array which contain those properties: ID SharingLink Password then I am building an HTML table >> so how can I get the Array's SharingLink values ...
microsoftdeveloperdesigner's user avatar
0 votes
1 answer
382 views

In Power Apps, how do I refer to the application in code?

Let's say I have an application, "My Power App", in Power Apps. How, in code, do I get the property "My Power App" to put it in a log, for example? Power Automate has the workflow()...
CigarDoug's user avatar
  • 1,063
0 votes
1 answer
272 views

Field A in the Power Apps should be only visible AND required if Field B (Number) starts with 6 or 7 in power app

Field A in the Power Apps should be only visible AND required if Field B (Number) starts with 6 or 7 in power app.
ABC's user avatar
  • 1
0 votes
1 answer
3k views

How to extract ONLY numbers from string using Power Automate

I have free text column in Dataverse table where alphanumeric values are entered e.g. abc123, 123abc, 1abc23. (numbers can be anywhere in string - no fix pattern) I want to extract ONLY numbers and ...
Guy World's user avatar
0 votes
2 answers
24 views

How to express this condition in SharePoint Calculated field

How to express this condition in SharePoint Calculated field? A field should have a result of yes or no with below condition: If ALL the fields value is completed answer should be No, else Yes.
jeanggerr's user avatar
0 votes
0 answers
60 views

SPOL Calculated Column Formula Help - Working Days

I’m trying to find the solution to 2 calculated column requirements. I have searched quite extensively and have only found partial, or partially working answers. The two requirements are: Work out the ...
MJI's user avatar
  • 1
0 votes
1 answer
172 views

Send Rest API's Post Query which should be Sorted by formula

I am trying to send a request using SharePoint 2013 Rest API (POSTQUERY) and my sort-list is a formula. When I am sending a GET request, it works fine as mentioned in below example: http://localhost/...
Adleron's user avatar
  • 53
0 votes
1 answer
151 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 ...
AutomeShane's user avatar
0 votes
0 answers
276 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 ...
cjs's user avatar
  • 1,214
0 votes
1 answer
612 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 ...
Samantha Douglas's user avatar
0 votes
0 answers
31 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 ...
Kirk Norton's user avatar
0 votes
2 answers
37 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 ...
Marnee Wade's user avatar
0 votes
1 answer
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, ...
olops's user avatar
  • 21
0 votes
1 answer
25 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 &...
Tim Sarai's user avatar
0 votes
1 answer
29 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 ...
Bruno Soares's user avatar
0 votes
1 answer
40 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 ...
MB1's user avatar
  • 1
0 votes
1 answer
979 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 ...
sonia's user avatar
  • 1
0 votes
0 answers
124 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 ...
Suzanne Ash's user avatar
0 votes
0 answers
180 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 ...
Dazza's user avatar
  • 767
0 votes
2 answers
938 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 ...
MarkR's user avatar
  • 15
0 votes
1 answer
419 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(...
GuikPoint's user avatar
0 votes
2 answers
872 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?
vier111's user avatar
  • 145