Tag Info

New answers tagged

0

Generally the OOTB Replace string/utility action is what you want to use, but SPD throws an error if you try to leave any of the action parameters empty, so the trick is how to tell it to replace " " with "". In a 2013 Workflow (in SPD2013), just make local variables to hold your Space and Empty String, then use them in the Replace action, like this... Set ...


2

You cannot use it as a number. You have to "convert" your value to numeric in order to make the validation, otherwise it will be "false". You can use the VALUE function to convert a text representation of a number, or simply add a number to your value to get it interpreted as numeric. =IF([ChoiceField1]+0<=2, 0, {nested IF if false}) or ...


0

=ROUNDDOWN(amount/1000,0) Help with formulas : https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx As Danny stated, most basic functions in Excel are working in a calculated column in SharePoint.


0

I have a list with tasks that all have to be finished within a certain deadline. I wanted the list to show me which deadlines were getting closer or were exceeded. After a long search on the internet I found there was no satisfying solution to make a column using the current date. However, I found out that when you modify the view of a list, you can put ...


0

I received some help from a friend, and from some posters on the MrExcel board. The formulas offered up do work for this task First =MID(A1,20,FIND("\",MID(A1,20,255))-1) where the character count of "20" is the set number of characters in the front, known string +1. another formula for doing it relies on the three \ characters and looks like this ...


0

The Path to SharePoint approach - the site everyone references is based on the 2007 way of adding HTML to a List View. It is kinda like trying to operate your iPhone 6 with an Apple-II manual and a great example of why you should exclude Google Results from over a year old in your searches. Since SharePoint 2010 there is no need to add extra JavaScript to ...


1

=IF(AND([Column4]<500, OR([Column3]=5,[Column3]=6,[Column3]=7,[Column3]=8)),DATEDIF([Column1], [Column2],"d"),"") This will return the number of days between the two dates. Help with calculated columns : https://msdn.microsoft.com/en-us/library/office/bb862071(v=office.14).aspx


0

The formula will be something like this: =IF(AND([Column 4]<500,OR([Column 3]=5,[Column 3]=6)),[Date 2]-[Date 1],"-")


3

Formula will be something like this: =IF(OR([Column3]="5", [Column3]="6"), [director approval date]-[finance approval date], "-") Here is the reference Example of common formulas


1

Maybe you can use another list to store your date in a dummy item. Then read that date from a workflow at creation of the item. Add the number of days you want to the source date and store it in your item. Custom List with a date column Dummy item with reference date SharePoint Designer Workflow on destination list, starts at creation Retrieve reference ...


0

What is your [ME] formatting? On my Office365 environment it is: i:0#.f|membership|username@domain.com I have to Creat my own Column ME in the List/Library Creat a Calculated Column with Formula: =RIGHT([ME], LEN([ME])-FIND("membership|", [ME])-10) Delete the Column ME And before I can make a change to the Formula I have to recreate my own ME ...


1

To remove domain part, you can try the following formula =RIGHT([Me], LEN([Me]) - FIND("\", [Me]))


0

Add a number Column 'Completion changed' (don't need a Calculated Column) Add a text column 'previous Completion Date' Create a SharePoint Designer Workflow Set to trigger on Item changes Workflow steps: read value from previous Completion Date read value from Completion Date if values are equal then do nothing if values not equal then read value from ...



Top 50 recent answers are included