Questions tagged [function]
The function tag has no usage guidance.
9
questions
0
votes
1
answer
678
views
PowerApps Form - Multi Select People Picker Field - How to split these values into two separate Text Labels
I have a PowerApps form (customized SP form), where I have a multi-select people picker field (Approvers) - The user may select up to 2 Approvers. I also have two text labels beneath it. I want to ...
0
votes
1
answer
688
views
PowerApps Form Validation - Not on Submit
I have an App (PowerApps) that includes 8 different Forms on 8 different screens that the User freely navigates and fills out info. Among these Forms are several different Required Fields. I'd like ...
0
votes
1
answer
23
views
I am using an IF function for a column but its giving me an error and I am not sure what the problem is. Can someone please help?
My formula:
=IF(AND([Column 1]="Low",[Column 2]="Low"),
"No",
IF(AND([Column 1]="Low",[Column 2]="Medium"),"No",
IF(AND([Column 1]="...
0
votes
1
answer
29
views
The Function Sum(IF(AND())) Statement is not calculating correctly
If my
[STARTDate] = 12/24/2020 AND [ENDDATE] =1/4/2021
It gives me a total of 3 days.
SUM(
(IF(AND(DATEVALUE("12/24/2020") >= [STARTDATE],DATEVALUE("12/24/2020") <= [...
0
votes
1
answer
703
views
Using Count values in another function for my Chart.js Pie Chart
Using Chart.js to display a Pie Chart.
However, I'm hard coding the data values.
Below is the entire code:
$(function(){
//Start Data Pull
//End Data Pull
//get the pie chart canvas
var ctx1 =...
0
votes
1
answer
84
views
unable to concatenate the first 3 characters of one list field with another list field in shareoint infopath form
I am trying to concatenate a designator field that combines my autonumbered index field with the first 3 characters of my group field
Index field automatically incremented current Highest index +1 I ...
0
votes
1
answer
2k
views
Cumulative sum of a column
What function can I use to create a calculated column [Cumulative Meters] that will sum [Meters] for each row? I can only seem to get a single overall sum for [Meters] using the Totals tool in ...
-1
votes
1
answer
45
views
What is the difference between a SharePoint Specialist, Consultant and Engineer? [closed]
What is the difference between these job functions: SharePoint Specialist vs SP Consultant vs SP Engineer?
I am really confused and which one pays better?
8
votes
2
answers
18k
views
SPFx - How to call function on button click event from ts file with React
How to call function from ".ts" file for button onClick event in tsx file?
this is my function in ts file:
public button_click(): void {
alert("CLICKED!");
}