Questions tagged [conditional]

Questions related to conditional statements

Filter by
Sorted by
Tagged with
23
votes
4answers
65k views

Color code item row based on column value in SharePoint Foundation 2013

I have a custom list which contains a field called Status. In the AllItems view, I would like to color code each line item based on the value of Status. Is this possible to do withing SharePoint ...
4
votes
4answers
588 views

How do I create a calculated conditional column using today's date, and automatically update each field daily?

I have created the following list (Timeframe) in SharePoint; Timeframe Start Date End Date Another column, [Is Current Timeframe], needs to be created that specifying whether or not the Timeframe ...
3
votes
2answers
10k views

Failed on Start (Workflow was canceled by System Account.)

When I add an "if condition" to my working workflow, It doesn't work anymore and gives error: "Failed to Start". (Workflow was canceled by System Account.) My "if condition" is in below image framed ...
3
votes
1answer
68 views

Conditional Formatting for UK (non-US) dates in custom list

I work in a compliance office and I convinced my boss to start using SharePoint services and part of my job is to build a compliance tracker with dates etc. I found a good solution here and after ...
3
votes
2answers
819 views

Conditional formatting in SharePoint Workflow Email

I have an issue where I have several check boxes (yes/no) on a form that my users fill out. Once they submit the form, it fires off a workflow to request work be done by the IT department. In the ...
3
votes
2answers
3k views

Calculated column value with IF statements

I created a calculated column named"total value". And I have some other columns named "Value1", "Value2", "Value3". And I created another Choice condition column named"Type". I want to archive that ...
2
votes
4answers
16k views

Workflow : test if a value is empty

I would like to start some actions in a workflow when a field doesn't have any value, when it doesn't have already been filled out. But when I choose the condition if a value is equal to a value, I ...
2
votes
2answers
74 views

How do I define the priority of conditional formatting in sharepoint designer?

Let's say if I have two conditional formatting for a list: if category = cat, background color change to red if location = foo, background color change to grey. Now, if the item has the category ...
2
votes
1answer
37 views

Use conditions in calculated column in sharepoint 2013

I want to make a formula in my calculated column in this meaning please: if (Column1 !=null && Column2 !=null && Column3 !=null) Display Approved else let it empty
2
votes
1answer
56 views

How to check in a workflow 2010 condition if an element is exist or not?

The users can create items in a custom list. One element of the item is the "date of warning". If the user add a date he/she ll recive an e-mail on that date if the "status" is not "finished" yet. The ...
2
votes
1answer
731 views

Using Nested OR/AND In Designer 2010 Workflow Conditions

A series of actions in an SPD 2010 workflow I'm working in needs to run when quite a few conditions, arranged in an "If this AND that are true, OR if something AND another thing are true, OR (etc)" ...
2
votes
2answers
40 views

SharePoint Column JSON formatting alignment

As mentioned in the Title I have some issues with trying to align my background color formatting as shown in the screenshot below: What I hope to do is to get the BACKGROUND COLOR to align WITHOUT ...
2
votes
1answer
2k views

InfoPath form: How to display value in a text box based on selection in previous drop down field

I have a form with a field in it called TypeOfCare. users can select five values from this menu: 'Residential' 'Residential EMI' 'Nursing' 'Nursing EMI' 'Care At Home' Depending on what user ...
2
votes
3answers
4k views

Can you use multiple 'if's in a workflow?

For example, I want a workflow to send when First name equals "John" AND when the last name equals "Smith." But I don't want the workflow to send when the workflow is for someone named John Doe or Tom ...
2
votes
1answer
283 views

Link to Edit button on page for item & conditionally format

In SharePoint Online (E3 subscription) I have 5 lists in a site and in each list the user is to enter 1 item. The end result is to enable the Create and Edit button conditionally on a page next to ...
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
2answers
235 views

Conditional formatting on list SharePoint 2013

I work for an organization that has crippled much of the functionality when using SharePoint 2013. Furthermore, I am still rather new to SharePoint. I am seeking a way to apply conditional formatting ...
1
vote
1answer
150 views

Sharepoint 2013 - issue with using java script to format columns

I found a few tutorials to do this, many of them point to using the jslink or content editor. I tried following the instructions in this site: CSR code samples #1 (Task Priority color) but it's not ...
1
vote
2answers
2k views

Conditional Formatting not applied to web part?

SharePoint Server 2010. In SPD, I have applied Conditional Formatting to a document library row, so the background changes color based on a column value in the row. Works great when viewing the ...
1
vote
2answers
86 views

SharePoint Online - Conditional Formulas For Columns

I've finally convinced management to let me build some decent apps with SharePoint Online. I am trying out the stock issue tracker and I have a question about Column Validation. We have a column ...
1
vote
2answers
18k views

How to filter SharePoint list column with username of the current user

I need to pass the current user name in the filter for Contains condition - Whenever passing [Me] it gives error: Filter value is not a valid text string.
1
vote
1answer
59 views

SharePoint Designer 2013 - And/Or priority in if statements

Using SharePoint Designer 2013, I'm actually doing some if statements in a workflow with or and and in the condition. But I'm confused as what priority is given for these... Is the and joining the ...
1
vote
2answers
400 views

PowerApps Conditional formatting

Looking for advice on how to implement a conditional formatting based on several factors. I'm still working on my Raw Materials Inspection app: We have 2 factors to consider: Probation and Time. If ...
1
vote
2answers
2k views

SPO Conditional Formatting - Color Column views

I have 2 columns namely: "Status", Choice column with Red,Yellow,Green as values "Comment", Multiple Lines of text column Now, I want to set the background of "Comment" column using the color ...
1
vote
1answer
655 views

Is it possible require an attachment when a specific drop down option is selected?

I have created a SharePoint list that automatically sends an email upon submission of a list item. One of the features I've added is a flag indicator '[*]' at the beginning of the email subject line ...
1
vote
1answer
19k views

SharePoint Conditional Formatting without using Designer

I am trying to apply conditional formatting to my SharePoint list based on a few conditions. For example I have a column (Month Needed) that the user selects a date from a drop down list in the ...
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
74 views

Powershell “Canot index into a null aray”

I have a powershell script which works but at the same time it throws this error. Cannot index into a null array. At D:\PowerShell\Items\Update_a_Field.ps1:10 char:69 + if($list.BaseType -eq "...
1
vote
1answer
138 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
232 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
1answer
61 views

Calculated Columns with Conditions

I have found plenty of posts that mentioned how to add multiple conditions to calculated column but my formula is not working. The action is pretty simple that is why I feel like silly that it has ...
0
votes
1answer
26 views

JSLink not modifying text

I am trying to get a super simple JS script to work on my SharePoint. I found this example here. This is what I am working with: (function () { var statusFieldCtx = {}; statusFieldCtx.Templates = {}; ...
0
votes
1answer
196 views

Is it possible to dynamically refresh a calculated field on the Edit form when a connected field is changed?

On the Edit form, I am trying to dynamically have a calculated field show updated values when the connected field is changed. The idea is to give the user more details on the selected week. Is this ...
0
votes
1answer
31 views

How can i nest column validation in SharePoint

How can I nest column validation =IF(OR( [Position]="Ground Support Equipment - Ramp Equipment Operator (GSE-REO)", [Position]="Ramp Equipment Operator (REO)", [Position]="Cargo Checker", ...
0
votes
2answers
956 views

Conditional formatting in item view (display form) using CSR / JS / CSS - is it doable?

Is it possible to apply conditional formatting to an item view [Display-Form] just like in the list? I use SharePoint Online, Cisar and SharePoint extensions for Chrome.
0
votes
1answer
68 views

Conditional fields - basic IF validation

I have what I imagine is quite a basic question for you SP folk. There are two drop-down lists. If the user chooses either of three options out of seven from the top drop-down list, the second field/...
0
votes
1answer
100 views

Can conditional mandatory field be made in SharePoint forms?

My Situation: I have a SharePoint list with a couple of fields used to make a printer directory. A the moment i have the Yes/No field "Network printer" to determine if i have to collect additional ...
0
votes
1answer
19 views

Value of the Yes/No Column

What is the values of the Yes/No Column in SharePoint? 1, 0 Yes, No "Yes", "No" True, False Trying to use calculations: =IF([Col1]=Yes, 1, 0) So if it's true, put 1, else 2. But not matter what, ...
0
votes
2answers
294 views

Condition: if value contains multiple strings

I'm not too great at the string builder or lookup fx's. I'm dealing with folders and want an approval process to go to User A if the folder is named "ABC" or "DEF". I'm using the condition: if any ...
0
votes
2answers
77 views

Sending multiple emails (possibly any multiple steps?) inside an if block

Trying to send two emails to two different groups once a certain test passes. If emails should be sent, send to group one - if a second test passes, send to second group. I have it set up like so: ...
0
votes
1answer
165 views

Is it possible to apply condition on Choice column in SharePoint Library?

There is one library having choice column as(Morning/Afternoon/Night). So requirement is that Allow user to choose morning only in morning time frame only. same for other Afternoon/Night. So how can ...
0
votes
2answers
12 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
1answer
69 views

SharePoint JSON tileProps breaks formatting

I am attempting to troubleshoot a formatting issue with JSON and actually found a Microsoft example that has the same problem for me. I developed a list using the same column names as the code below: ...
0
votes
1answer
33 views

Powershell script to update list column from another column Conditional

Any help is greatly appreciated. Here is the scenario: I have a powershell script which I am using from another post on stackexchange. I have two fields in a list, the script copies the value from ...