Questions tagged [syntax]
The syntax tag has no usage guidance.
39
questions
0
votes
1
answer
27
views
My Syntax Error Calculation in SharePoint List is not worked T_T
I have so so BIG problem!!
So, I'm trying to generate the verdict syntax calculation, but it shows the wrong answer.
Please help me T_T.
The pictures show the filled value from 2 columns before. In ...
- 1
0
votes
0
answers
107
views
Updating Sharepoint list multi-choice field with excel VBA SQL code
For a given sharepoint list, I am trying to create a row via an SQL statement.
My SQL statement is as follows:
sql = "INSERT INTO `My Sharepoint List` (`Title`, `Lead`, `Part`) VALUES ('Project1',...
0
votes
1
answer
33
views
Choose non Blank field
I have a sharepoint list with multiple calculated fields. I am looking to roll the fields into one by choosing a final status. There are 6 columns. I want the formula to look at all six columns and ...
- 1
0
votes
1
answer
1k
views
Power Automate - Send email 30 days after date - Library
I have a Document Library (SP Online) in which users Upload documents, then they Modify the new File to add its properties. The user sets a Date column - "Published Date" manually after ...
- 373
0
votes
1
answer
458
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 ...
- 373
0
votes
1
answer
623
views
How to write multiple conditional formula (39 conditions) for 7 columns in Sharepoint
first, I must thank you all for the tips for new people who want to learn more on SharePoint to optimize their business.
I'm trying to find a solution to write expanded conditional formula according ...
0
votes
2
answers
489
views
Auto-Populate Date in Column When Seperate Column Gets Filled
I've checked around a few other questions asked around this, but none have really applied to what I am looking for.
Using Sharepoint 2019 Online, we have a sheet that contains 12 different columns. ...
0
votes
1
answer
258
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
1
answer
37
views
SharePoint 2013 Formula Syntax: Choice Column Generates Number in Another Column
I am trying to make the following happen on a list: If a user selects "Most" as a choice, then another column will return as 1. If a user selects "Somewhat" then that column will return a .5. If a ...
- 1
1
vote
1
answer
364
views
document library validation formula
I have a CATEGORY column which has 4 choices (A, B, C, D) and is mandatory.
I have a second column (lets call it TYPE) which can have content (but is not mandatory).
What I want the validation to do ...
- 11
0
votes
2
answers
49
views
Need help with JS syntax
I want to show/hide a div based on the value of a SP dropdown/choice column on form.
I have written below code to this which is not written correctly.
Can anyone help me with syntax to correct this?
...
1
vote
1
answer
70
views
SharePoint Filters and Custom Views Total Calculations
I have a Date column where users can enter any date they want, I also have separate column that shows the month of that same date column.
I am trying to create a filter that will count how many ...
- 155
1
vote
2
answers
1k
views
Calculated Column Syntax nested DATEIF and ISERROR
This is for SharePoint Online
I have a calculated column that takes info from 2 date columns and calculates the number of days. Some times one of these columns wont contain data. This will then ...
- 155
2
votes
2
answers
5k
views
With Powerapps, how can I make a field conditionally mandatory?
I'm trying to make fields conditionally mandatory for example, if Status field = "Red", make the Comments field required.
I can see where I can put a formula in the 'required' section of the Comments ...
- 21
0
votes
1
answer
210
views
Using Choice Data Type in Validation Formula
I am working on a validation to determine if a selected choice is okay based off a previous selected choice.
There are a number of categories (labeled 1 thru 13). Category #1 and Category #13 can ...
- 407
1
vote
2
answers
409
views
How do i get a choice column to change from YES to NO depending on another column using calculated columns
I'm trying to uses nested ifs to change what a choice column displays but I'm not sure if this can be done or if I'm doing it properly. What I'm trying to have accrue is once the next review date ...
- 155
1
vote
1
answer
405
views
Perform a calculation based on other criteria
sorry in advance supernoob here failing hard and need help. I'm trying to create a timesheet in sharepoint that will eventually be a powerapp then go into PowerBI and I'm struggling bad with the ...
- 11
5
votes
1
answer
473
views
Column Validation Settings for a mandatory choice
I have a SharePoint 2013 list with 3 dropdowns of which 1 must be selected. It doesn't matter which is selected as long as one of them has data. I tried to do the Validation Settings:
=IF(AND(...
0
votes
1
answer
2k
views
uncaught syntaxerror unexpected identifier
I am trying to make some tabs that pull a webpart from the page and place the part in the tab, using Jquery's easyUI tabs. However, I am getting a syntax error in the following code:
<!---->...
- 319
0
votes
1
answer
34
views
Is any of my data within a date range in February?
I am trying to see if a particular date range has any values in February. I tried using a range in an IF statement with 2 conditions (see below). I am getting a syntax error. Here is what I'm trying:
...
0
votes
1
answer
156
views
List Validation formula help!
I am creating a record center and am having issues trying to have one column (column1) get information from end user and that their answer (choice-dropdown) will determine next set of options that ...
- 3
1
vote
1
answer
410
views
KeywordQuery Syntax: column contains "abc" OR column contains "xyz"?
What is the syntax for column contains "abc" OR column contains "xyz"?
Here is my query:
*
Category:Castle Black OR Category:Kings Landing
Separately "Castle Black" returns 4 results, and "...
- 737
5
votes
0
answers
131
views
Multiple validations in a single column in 2013
I have been working on something I feel should be very simple for far too long. I have a single line text column in a list and would like to employee multiple validations to the column. The ...
- 51
11
votes
1
answer
4k
views
REST API Query Syntax
I'm trying to pull back all Projects that are Active and have a ProjectName="X". ProjectName is a lookup and Active is Yes/No. Here's what I have built:
http://<siteurl>/_api/lists/getbytitle('...
- 3,905
2
votes
4
answers
243
views
Script syntax and passing issue
I want to call the function startWorkflow() in line 651 and pass two variables.
But I don't know how to do that. If I am calling like in the line 649, everything works like a charm.
I tried a lot, ...
- 3,173
3
votes
2
answers
18k
views
Calculated column - using multiple AND and IF functions
I have been trying to figure this out and I cannot solve it.
I am trying to create something which say IF column a = "High" AND Column b ="High" THEN "Red" should be inputted. So far I have...
=IF(
...
- 33
2
votes
2
answers
1k
views
Can't get calculated column syntax right
This "ought" to be easy and yet as with so many things SharePoint, it isn't. I have a calculated column where I keep getting a syntax error. If the user sets a dropdown column value to x, then y ...
- 21
0
votes
1
answer
43
views
I received an error for my calculated field 'syntax error or is not supported
The following is the calculation that has worked on a number of SharePoint sites, but when I tried to enter it on a new site I got an error message . Here is my calculation. Can anyone help? Does ...
- 1
-2
votes
1
answer
794
views
Specify field to apply .css style
I have a field in SharePoint list. I am trying to apply a background color in the display form. Name of field is Process Instruction.
I am having trouble with the .css syntax. It Works fine in IE ...
- 77
0
votes
2
answers
1k
views
SharePoint 2007 calculated column formula: Syntax error
I have list with a bunch of yes/no checkbox columns. I'm trying to create a column that counts how many fields in the row have the value 'Yes'. I found an inelegant formula that is supposed to do just ...
- 141
1
vote
1
answer
34
views
Apply format when calling template
I am stuck on a syntax issue. I have the following table data
<td>
<xsl:call-template name="DateDiff">
<xsl:with-param name="firstdate" select="@Current_x0020_POP_x0020_End_x002" /&...
- 11
0
votes
1
answer
75
views
Need help with a formula
I need some help. I have created a pretty extensive list at work for my colleagues to use to track financials on some of our projects, I am using a formula one of the project managers had established ...
2
votes
2
answers
2k
views
Content by Search WebPart to search only in subwebs
Is it possible (and when yes, how?) to configure a Content by Search WebPart (SP2013) to search only items in current web and subwebs?
For example I have a CBSWP on a page with path: http://site/web1/...
- 589
3
votes
2
answers
2k
views
Remove LI wrapper from Content Query Web Part / ContentQueryMain.xsl
I have done a fair amount of experminting with this but cannot get it to work and I'm now looking for pointers or working examples.
I want to customise the output of the Content Query Web Part to ...
- 91
0
votes
4
answers
5k
views
Trouble with IF formula
We have a task list with a column that categorizes tasks into one of 12 categories. We're trying to calculate a NEW column that will be populated with one of two values, "Technical" or "Procedural" ...
- 945
3
votes
1
answer
2k
views
Wiki Syntax to Create Child Page From Current Page
This seems like it should be a very simple task/question.
We are currently on SharePoint 2007.
I am in the process of editing a particular department's Wiki page, so imagine the breadcrumb to the ...
- 133
0
votes
1
answer
955
views
Output of SharePointWebControls:LookupField inside an <a> Tag?
I have a lookupfield which is containing an E-Mail Adress and want to have it inside an Tag.
How is this Possible?
Like:
<a href="mailto:<SharePointWebControls:LookupField FieldName="...
- 475
3
votes
1
answer
275
views
Where can the [%= %] dynamic token syntax be used?
I am looking at the old REPORTCENTER onet.xml file in SharePoint 2010's 14 hive (SharePoint Root). I noticed the following in this file:
<Configuration ID="1" Name="Blank">
<...
- 1,612
1
vote
5
answers
2k
views
for vs foreach when iterating over SPWebCollection
I was just wondering which of the two methods below is more popular, when it comes to iterating over a collection of SPWeb objects.
for (int i = 0; i < SPContext.Current.Site.AllWebs.Count; i++)
{
...
- 5,040