Conditional Operations on Read Only Fields when Record is Modified

MaxPower

Scenario

Two Fields

Responsible

Date Closed (read only)

Requirements

1) When the record is updated, if Responsible equals "Closed", automatically populate Date Closed with TODAY()

2) When the record is updated, if Responsible does not equal "Closed", automatically populate Date Closed with blank

What tools/methods can be used to satisfy these requirements?

Find more posts tagged with

Healthcare

Formulas

IT & Operations

Comments

Shaine Greenwood

Hello Max—You could use an IF formula that will populate the current date as long as your "Responsible" field is equal to "Closed." An example of what this might look likeis as follows:

=IF(Responsible1 = "Closed", TODAY())

Keep in mind that this will continue to populate the current date as long as the condition is met (in this case Responsible being equal to "Closed") and we don't have functionality to return only the date a specific value was entered in a cell.

J. Craig Williams

Max,

This will work if the row is not updated after closure:

=IF(Responsible1 = "Closed", MIN(Modified1, TODAY()))

You can add a notification when the Responsible column changes for an Admin user to lock the row -- but that only protects against non-Admins

Hope this helps.

Craig