Questions tagged [conditional]

Questions related to conditional statements

Filter by
Sorted by
Tagged with
0
votes
1answer
16 views

how to make sharpoint list fields visible for certain users

I have set up a sharepoint list I maintain myself with my manager. There is a subset of fields that are needed to see and updated by the team. For that I created a new view that only displays the ...
1
vote
1answer
38 views

How can I display a "View Comments" link on a list item only when comments exist?

My SharePoint list has a column for comments. It used to display a link to "View Comments" for every list item, though, even if there were no comments. Not helpful, since a user would have ...
1
vote
1answer
37 views

Conditional format based on Time Range in Sharepoint list

is there a way to conditional format based on the time range or time value? i have a SPO list where employees have a daily task that is due at 5pm everyday. i wanted to conditional format the column ...
1
vote
1answer
61 views

CONDITIONAL FORMATTING - Unable to format column

I have a SharePoint LIST that's being used to manage events. There are 6 participants for each event and each Participant has a column: "Participant 1", "Participant 2", "...
0
votes
1answer
51 views

Conditional Formatting with date comparison

I am using SharePoint 2016 on Premise in the classic mode. I have a Custom List, and I want to apply conditional formatting to a date column, so that if the date is overdue from today's date it will ...
0
votes
1answer
314 views

How to hide a SharePoint list column if its own value is empty?

Is there a way with SharePoint online lists, to hide a column if the user did not fill in a value for it? If so, how can I setup this conditional logic for the column to check against itself? I have ...
0
votes
1answer
13 views

How to set up limited, web-only access for unmanaged devices BUT grant saving/printing for external shared files?

Community, I need some help with different access controls for unmanaged devices in my company. Users inside the company having limited, web-only access to SPO sites and content, if they are using ...
0
votes
1answer
534 views

JSON Sharepoint Calculated Columns

First time coding with JSON and need a little help...... I am attempting to make a calculated column with conditional formatting. So far i can get it to work but only partially. What i want is to have ...
0
votes
1answer
24 views

SP2013: Disable text or number field once populated

I am looking for a jQuery script to conditionally disable two field types: Disable a text field if it is not blank and Disable a number field once it is non zero. I see many posts on disabling ...
0
votes
1answer
368 views

Conditional table cell background color depending on value

I have a HTML table that I'm trying to change the cell background color to red depending on the value of the cell. Each cell will have a different threshold for when red is needed (one cell might be &...
0
votes
0answers
13 views

Conditional formatting based on set of values

Am trying to format a field in sharepoint form designed in Infopath 2013, based on set of values. There are 81 department codes to be precise, and if my value is in any one of those, I need to change ...
0
votes
1answer
25 views

Multiple if statements to calculate numbers

Need to calculate numbers from columns when status changes in other columns. Column one has the number of hour assigned for shift 1. Column two has status of completion, this repeats for 10 shifts. ...
1
vote
1answer
1k views

Conditional formatting based on number of days to due date

In SharePoint 0365, in the modern experience, I have a list of contracts that have an expiration date. I would like to use conditional formatting to create a status column that shows me the contract ...
0
votes
2answers
127 views

How to make a conditional question in Sharepoint List/PowerApps?

I have a SharePoint List that I have customized with PowerApps. It has 3 questions that need to be answered only if the question before the 3 questions was answered. So if the applicant gets to the ...
0
votes
1answer
44 views

Automate recreate list item with new date

Wondering if someone can provide some input on this -- I am a super-novice to Microsoft Flow so was not able to find a way to accomplish, but I believe this is technically feasible. I have a SP (...
2
votes
1answer
164 views

Display different flow buttons in sharepoint list with time condition

I have a list where an item can have different statuses (Draft, Planned, Updated and finished) I wanted 3 different flows to be able to run, so the buttons are: When Draft: [Send item] When Updated: [...
1
vote
2answers
689 views

JSON - Conditional Formatting - SharePoint - Not Null

New to JSON. Trying to write JSON when ever a free form text field is filled out, have this but don't know how to get it to highlight when anything is entered. I do not want highlights on blank items: ...
0
votes
1answer
39 views

Sharepoint survey- drive questions from answers to earlier rating question

I have a survey of a product portfolio. The first question is the rating question covering all products in the portfolio. I then want subsequent question section for each of the product that had a ...
1
vote
1answer
55 views

Sharepoint JSON conditional syntax help

I am trying to make the text say Expired or Current compared to a date column OR stay blank if the date column is blank. So far, I have: "txtContent": "=if([$ExpiryDate]) == '', '' , ...
0
votes
1answer
123 views

JSON Sharepoint - validating dates across several columns with boolean column

I'm beginner/intermediate when it comes to SharePoint JSON, and I've been trying all sorts of conditional logic to make an empty column txtContent show 'Yes' or 'No'. There are 7 columns (all date ...
0
votes
1answer
24 views

Lookup doc library column showing options based on List other column's value

I am currently setting up a document management system in our SP Online system. A column of the Doc Library is called "Project Name". I created a List ("Project List") containing the Project Name ...
1
vote
2answers
34 views

Sharepoint workflows: Is it possible to conditionally execute steps within a stage?

EXAMPLE: Stage: Get Approval if (CurrentItem:Amount) < 100) then Get Manager Approval else Get Manager Approval Get Finance Approval Q: Is it possible to make "Get Manager ...
2
votes
1answer
48 views

SharePoint List column validation related to another item

I have a SP list with 3 fields: "report type" (choose list "A", "B" or "AB") "Type A due date" "Type B due date". I want to set-up column validation for the due date so that "Type A due date" is ...
1
vote
1answer
29 views

Conditional formatting for a row that contains any information

I have a list that I am using for a library check out. When a person populates the check out date field I want my row to be grayed out. The condition would be if a field contains "any" information. ...
0
votes
2answers
14 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
1k 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: ...
2
votes
2answers
3k 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 ...
0
votes
1answer
539 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
1answer
388 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 ...
0
votes
1answer
37 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 = {}; ...
1
vote
2answers
850 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
13 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/...
0
votes
1answer
1k 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
835 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
26 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
538 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
1k 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
890 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
5k 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
779 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
480 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
28 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
301 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
35 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
2k 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
39 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
239 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 ...
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
364 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, ...
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 ...