1

How to get today's modified date in calculated column when someone selects Done in another list choice column.

The list has some values like as Not Started, In Progress, Done

3
  • You have two list, one list contains calculated column and other list contains choice column. m I right Oct 12 '16 at 12:22
  • You can use this formula to get modified date for item only if Status is Done Stats is Choice Column =IF(Status="Done",Modified,"Nothing") Oct 12 '16 at 12:39
  • Here is syntax for calculated column IF(logical_test,value_if_true,value_if_false) Oct 12 '16 at 12:41
0

Here is syntax for calculated column If condition

IF(logical_test,value_if_true,value_if_false) 

Example

IF(Status="Done",Modified,"Nothing")

In above example Status is Choice Column

If status is Done then only it get modified column value

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.