Hot answers tagged


I don't know about Swedish but in German you have to use ; instead of , in Formulas. Maybe try that


Here is the Form validation formula: =IF(NOT(ISBLANK(DueDate)),IF(DueDate>(TODAY()+(7-WEEKDAY(TODAY(),2)+1+7)),TRUE,FALSE),TRUE) Find days from TODAY() to the first Monday using WEEKDAY(date,return_type), where date is TODAY(), return_type=2. It returns weekdays numbered 1 (Monday) through 7 (Sunday) Add days (step 1) plus 1 to TODAY() to get the first ...


You can not achieve this using Calculated column. One option to this is SharePoint Designer as explain below - Create 3 date columns each for Start Date, Pause Date and End Date. Create a SharePoint Designer workflow that will trigger when an item is created and when an item is modified. Write below steps in workflow to compare Stage value and accordingly ...


Figured it out. I was able to use the DATEVALUE function to convert the text string to a date where I then can compare it to values like [TODAY]

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