New answers tagged

0

You either need to use a workflow and add the condition only if the dropdown value is changed.For this you need to setup a field which would hold previous value. On edits, you need to check in the workflow new value to old value, that is how workflow condition would validate a choice change. If true, then set the date field in workflow. If you want to go ...


1

Calculated columns always re-calculate when an Item is updated. That is by design. If you want a field to only update conditionally based on some rule, you will need to create a workflow. For your specific scenario, first create a Hidden text column named "OldStatus", then change your "CHANGE" column to be a non-calculated Date column, and also make it ...


Top 50 recent answers are included