Questions tagged [conditional]
Questions related to conditional statements
0
votes
1answer
25 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
0answers
23 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 ...
1
vote
1answer
34 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 ...
0
votes
2answers
22 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 ...
1
vote
2answers
58 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 ...
0
votes
1answer
29 views
PowerApps: Compound IF statement?
On my screen I have two fields called InspectionDueFreq and InspectionDueProb.
The former represents the frequency of inspections (in days). If, for example, a part is to be inspected every 30 days ...
1
vote
1answer
22 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
27 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
20 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
63 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 ...
0
votes
1answer
27 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",
...
1
vote
1answer
245 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,...
2
votes
1answer
35 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
1
vote
2answers
30 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
votes
0answers
13 views
Derived Text Field
I am super newbie.
I have a form with several fields. I want a field that will read:
- Incomplete: If at least one of the fields is blank
- Complete: When none of the fields are blank
How can I ...
0
votes
0answers
24 views
SPO color field based on based two column values
I am trying to format a field based on the result from another field in SPO.
Currently I have 3 columns: Impact, Safety, Color.
The workflow should be as follows:
User inputs an impact value (1-6)
...
0
votes
0answers
22 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
44 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
0answers
9 views
Trigger required fields based on Data Entered
I want to be able to make or highlight a field if another field has data.
For Example:
Field1 = Week Date (5/1/18)
Field2 = Week Of (4/3/18)
Basically, if a user enters data into field1 then field2 ...
0
votes
0answers
19 views
sharepoint 2013 master page conditional project property rendering
Right now I am using the below code to render the site description.
<SharePoint:AjaxDelta id="nSiteDescription" runat="server" BlockElement="true">
<SharePoint:ProjectProperty Property="...
0
votes
0answers
38 views
InfoPath Condition Evaluation
I'm working with InfoPath to integrate with SharePoint. Currently I have this as the condition for Validations on the Area field:
However, when Area has a value, it fails validation. What am I ...
1
vote
2answers
1k 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 ...
2
votes
1answer
36 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
498 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)" ...
1
vote
0answers
41 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 ...
0
votes
1answer
16 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 ...
1
vote
1answer
458 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 ...
0
votes
2answers
707 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
2answers
53 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
120 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 ...
3
votes
1answer
57 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 ...
1
vote
1answer
938 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
2answers
12k 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.
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 ...
0
votes
1answer
60 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
2answers
52 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
72 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
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:
...
3
votes
2answers
2k 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 ...
0
votes
1answer
841 views
Custom Lists - Conditional Formatting Cells based on Dates on SharePoint2013
So I was tasked with creating a conditional to highlight an item red when the date is overdue. With some help from you guys I was able to produce a JSLink that highlighted the entire row when an item ...
0
votes
2answers
379 views
Custom Lists - Conditional Formatting Rows based on Dates on SharePoint2013
I'm new to JavaScript and I'm trying to highlight a row in a custom list red if the date is overdue. I've been tampering with this code for a while now and I can't seem to get any results. I'm pretty ...
1
vote
1answer
1k 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?
4
votes
4answers
508 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 ...
2
votes
2answers
8k 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 ...
0
votes
1answer
103 views
Creating EULA page with conditional redirect
I'm trying to create "EULA" page so everyone entering some sub-site will be compered against a list of users to see if he accepted the agreement.
I'm trying to implement it by conditional redirect ...
0
votes
1answer
67 views
Show top 10 distinct users in Sharepoint 2010 list based on another list
I am having a Sharepoint 2010 site where I'm having a List named UserRank which has columns User of type people & group and Datetime.
After each custom email webpart an entry to this list is ...
2
votes
1answer
261 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
4answers
13k 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
0answers
60 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 ...
3
votes
2answers
732 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 ...
