6
votes
JS Link - How to change a column based on another column's value
When you're in the rendering cycle, in your CSR override code, ctx.CurrentItem will have other field values. So for instance you could check ctx.CurrentItem.ProductionStatus (or whatever the internal ...
- 12.7k
3
votes
Status Indicator using Calculated Columns
Try referencing the following:
Color code item row based on column value in SharePoint Foundation 2013
https://blog.splibrarian.com/2012/06/06/using-calculated-columns-to-add-color-coding-to-your-...
- 2,346
3
votes
Accepted
Update Status of an associated Task in a SharePoint list Column (Field)
Because this plagued me for almost a week and it seems so many people have had questions about it I have decided to share what I learned in this process. After reading almost everything online and ...
- 46
2
votes
Status Indicator using Calculated Columns
@hoffie4
•https://blog.splibrarian.com/2012/06/06/using-calculated-columns-to-add-color-coding-to-your-sharepoint-lists/
Thank you so much! I found in the comments of the article you sent me that if ...
- 229
2
votes
Accepted
How to set ModerationInformation.Status Values in Powershell?
Add $Pageitem.Update() (or .SystemUpdate()) after assigning ModerationInformation.Status:
$Pageitem.Update();
You need to update the item after changing the metadata as well as after setting the ...
- 3,818
2
votes
Accepted
I am unable to enforce workflow to stop after first task rejected
If you are using SharePoint 2013 Designer Workflow, it is very easy.
Assign a task activity will have an outcome variable
Put a if condition under transition and check for the task outcome....
- 1,307
2
votes
Accepted
Stoplight (traffic light questions)
Check the CHOOSE function index parameter to avoid getting #VALUE! error.
="<DIV style='font-weight:bold; font-size:45px; text-align:center; "&IF(RIGHT(LEFT(CASES;2);1)<=0;"color:white";"...
- 1,737
2
votes
Using a status indicator “light” status column (calculated) in default view style (all items)
Note: Please mention the version of SharePoint you are using, so that its easy to provide the suggestions/answers
Is this for SharePoint Online? If yes, HTML within a calculated field will not work ...
- 723
1
vote
Accepted
Disable availability status for external users
Currently there is no way to hide availability status for external users.
Please vote for this feature in Microsoft Teams UserVoice:
https://microsoftteams.uservoice.com/forums/555103-public/...
- 4,217
1
vote
Mapping the Status property between the MS Word Property and the Status SharePoint site column
There is nothing we can do. The document properties do not have a column setting in Word client similar to the one in SharePoint library, yet changing the settings in SharePoint will not affect the ...
- 4,542
1
vote
SharePoint Versioning
Have you enabled minor versioning on the document library?
Minor versions will allow you to have drafts of the document and only editors/approvers can see the draft versions (this setting can be ...
- 713
1
vote
Accepted
Hide List item based on colum choice and time passed?
One option is to modify your list view:
In your list view, you could set a filter that states "Show the items when column 'Status' is equal to 'Open' (and whatever options you have other than 'Closed'...
- 164
1
vote
Accepted
Find the Workflow Status page for a running workflows
There was a very similar article written here that you can get this information using PowerShell.
How to get running workflow instances on listitems in powershell?
# Main
###########################
...
- 26
1
vote
Accepted
Using a status indicator “light” status column (calculated) in default view style (all items)
I found a couple of useful answers for KPIs:
Using calculated fields as KPI
Using Today and Me in Calculated Columns
Edits based on comments:
Make sure you calculated column is formatted to return ...
- 550
1
vote
Accepted
Status Bar and allerts
See: http://www.nothingbutsharepoint.com/2013/01/09/sharepoint-showing-notification-and-status-message-using-sp-js-aspx-2/
If you wrap this in a User Custom Action Scriptlink
http://johnliu.net/...
- 21.2k
1
vote
Accepted
How to forbid the closing of sp notification?
SP.UI.Notify.addNotification return id of the newly created notification (DOM element). It also attaches click handler on child div element, what you can do is unbind click event by replacing child ...
- 11.6k
1
vote
Editing Workflow Status Default value
Yes, it is possible to set workflow status.
Please use Set Workflow Status action in SharePoint Designer. Reference
Check also these guidelines for setting the status and its limitations.
If you are ...
- 2,445
1
vote
How to send an email when an item's status has been in pending for too long?
You can keep the current workflow as it is. Create a second workflow that pauses for 2 days and then checks whether the manager has approved or not. If the manager has not approved, then email the ...
- 2,099
1
vote
Update Status of an associated Task in a SharePoint list Column (Field)
When a SPD workflow creates a task, it outputs a item GUID representing the list item of the task created.
Using this GUID, you will be able to use the workflow action "Update Item in List" to ...
- 612
1
vote
Column Versions
You could use a workflow to update the second column. First capture the approval status as a variable, and when Approval Status changes, set the second column to be the variable.
- 334
Only top scored, non community-wiki answers of a minimum length are eligible