Questions tagged [function]
The function tag has no usage guidance.
8
questions
0
votes
1
answer
449
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
22
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
26
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
670
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
73
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
1k
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
43
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
17k
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!");
}