Questions tagged [syntax]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
22 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
vote
1answer
80 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 ...
0
votes
2answers
43 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
1answer
47 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 ...
1
vote
1answer
108 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 ...
2
votes
1answer
410 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 ...
0
votes
1answer
73 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 ...
1
vote
2answers
75 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 ...
1
vote
1answer
166 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 ...
5
votes
1answer
450 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
1answer
1k 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: <!---->...
0
votes
1answer
31 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
1answer
128 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 ...
1
vote
1answer
279 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 "...
5
votes
0answers
121 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 ...
9
votes
1answer
3k 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('...
2
votes
4answers
205 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, ...
1
vote
2answers
4k 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( ...
2
votes
2answers
776 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 ...
0
votes
1answer
41 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 ...
-2
votes
1answer
655 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 ...
0
votes
2answers
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 ...
1
vote
1answer
33 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" /&...
0
votes
1answer
66 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
2answers
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/...
3
votes
2answers
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 ...
0
votes
4answers
4k 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" ...
3
votes
1answer
1k 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 ...
0
votes
1answer
889 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="...
3
votes
1answer
256 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
vote
5answers
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++) { ...