Questions tagged [function]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
21 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
1answer
23 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
1answer
332 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
1answer
32 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
1answer
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
1answer
38 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
2answers
13k 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!"); }