Tag Info

Hot answers tagged


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


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 ...


=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


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


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 ...

Only top voted, non community-wiki answers of a minimum length are eligible