Hot answers tagged

2

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


1

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


1

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


1

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