Questions tagged [conditional]

Questions related to conditional statements

26 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
2
votes
0answers
66 views

Conditional Auto-Numbering in SharePoint

I want to replicate the excel "Countif" funcion in Sharepoint Site for Conditional Auto-Numbering of the list getting generated. e.g. Input Required Output A A-1 B B-1 C C-1 A ...
1
vote
1answer
11 views

How do I create columns that evaluate other columns cumulatively?

Im very new to SharePoint as a whole so please bear with me. Currently I am trying to create a checklist on SharePoint 2013 which features about 30 or so odd questions, each to be answered with Yes/...
1
vote
1answer
175 views

Sharepoint 2013 - Conditional validation on mutiple choice lookup column

Scenario: Sharepoint form created in infopath with multiple views. One multiple choice lookup column needs to be "Cannot be blank" for only one of the views. I have removed the ribbon save button and ...
1
vote
0answers
26 views

Multiple values in list

I am using SharePoint from Office365. Two lists are given: List 1: 1 | Person1 2 | Person2 3 | Person3 ... List 2: 1 | Activity1 | Person1;Person3 2 | Activity2 | Person2 3 | Activity3 | Person1;...
1
vote
1answer
1k views

Birthday & Anniversary Webpart (Slider)

I would like to create an share point web part (slider) on wiki page to display today's birthday and anniversaries with picture and description (like Date of birth, name, year in company etc). Since,...
1
vote
0answers
53 views

Conditionally Filtered Autocomplete Script based on another Column in a Form (SPO)

I am using the script below to autopopulate a text column called 'RelatedPeople' (Both Internal and External Column Name). The script pulls from the 'Title' Column of the 'People' List. I was ...
1
vote
1answer
1k views

SharePoint Conditional Formatting Date Column

I've been trying to create a Conditional Color column for dates that are expired. The expired dates should be red and the dates that are not should be clear. I tried to use the code from http://www....
1
vote
1answer
2k views

Conditional Columns in SharePoint List

Is there a way to have a Conditional Column with Multi-Line Text that will only show up in the list if a certain status is selected?
1
vote
0answers
233 views

Sharepoint Custom List conditional formatting date comparison

I am having an issue when creating conditional formatting using SharePoint Designer 2010. When the @Complete_x0020_Date is less than or equal to @Negotiated_x0020_Date, it will color the @...
1
vote
2answers
1k views

Use javascript/jquery to see if items in list are due soon in Sharepoint 2013

I am trying to determine by date if an item is due. In my use case, my user will create an item with a date in the following format (MM/DD or 06/15). Now if the date the user chooses will fall in the ...
0
votes
0answers
8 views

Conditionally formatting (hiding or revealing) rows in a custom form in SharePoint Designer 2010

I am trying to conditionally reveal/hide rows in a custom edit form in SharePoint Designer 2010. I am using xsl's starts-with test, but I am not managing to have it work. It only hides the row, even ...
0
votes
2answers
13 views

Can't get conditional syntax correct

Have [Tier] column with choice values of 0,1,2,3. If [Tier] = 0 calculated column should = 0 If [Tier] = 1 calculated column should = 4 If [Tier] = 2 calculated column should = 24 If [Tier] = 3 ...
0
votes
0answers
25 views

If any value equals any value condition doesn't accept two words

I am creating a workflow in SharePoint Designer and am using the "If any value equals any value" condition. I want to check if the current item is in a particular folder. The folder has two words to ...
0
votes
0answers
24 views

Conditaionl Formating of row when field is not displayed

Seems simple, but I cant figure it out. I want to highlight a row based on text being entered in a field, but the field is NOT displayed. It shows up the way I want if the field is showing up in the ...
0
votes
1answer
124 views

Sharepoint Conditional Formatting or Add Flag?

OK, so I'm trying to basically add an indicator of any kind in one field based on another field having data entered v no data entered. Ideally would like to display a red flag, or some kind of icon, ...
0
votes
1answer
18 views

Conditional formatting for email lists?

I am new to SharePoint coding and am wondering if there is any type of conditional formatting which will allow there to be an email sent to a specific group when a certain drop-down is selected. For ...
0
votes
2answers
59 views

conditional formatting with date not working properly. SPD2010

I created a conditional formatting on a column with date ('Due date') and it worked fine until yesterday. This morning I noticed its not working anymore. I open SPD2010 and remove the condition and ...
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
2answers
41 views

SP Designer 2007 - Conditional statement order

I've created a conditional statement in a SPD 2007 Workflow which has the following logic: IF 1 AND 2 AND 3 OR 4 I want this code to be understood as: IF 1 AND 2 AND (3 OR 4) However it is being ...
0
votes
1answer
152 views

Conditional workflow email automatically sent when a single field changes

I have a list (CRM) and there is a field where a representative is assigned. The rep gets an email when the field is filled in for the first time. How do I make a workflow so that if the rep is ...
0
votes
1answer
26 views

Build conditional fields in TO line of email

So I have checkboxes on an infopath form representing divisons in our agency. Depending on who the form creator wants notified they check the boxes for Opertions or Admin, or Grant Management or some ...
0
votes
1answer
162 views

route a document or not based on a condition for calendar entry

If a calendar entry is vacation I want it to route for approval else anything else I want it to auto approve and not route and automatically add it to the calendar Im new to sharepoint and tried ...
0
votes
2answers
75 views

InfoPath table calculated column: simplifying conditional statements

I have a table in SharePoint using InfoPath where I would like to have a Calculated column with a conditional formula based on the values of another column. I have a formula that works: =IF(OR(...
0
votes
1answer
44 views

Create AutoNumber for Duplicate Field

How do I create autonumber in SharePoint List where the field contain duplicates. I want to use workflow with condition to identify these duplicate items and set the ID. For example, there are several ...
0
votes
1answer
463 views

Impersonation Step that's dependent on an IF condition

I'm writing a workflow for a dispatch process in a warehouse. The item goes through several stages before it can be closed, and at each stage, the item must be edited by different groups. I'm ...
0
votes
1answer
124 views

SP 2010 - Lookup Column not working with Conditional Formatting

I have a lookup column for Tabs: Major Sub-1 Sub-2 Sub-3 Technical Pricing I need to setup conditional formatting so the row color changes with the level of tab selected. I can do this with drop ...