This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
I imagine this will be very simple for someone to answer, but in the date formula field, what is the proper syntax to populate that date field [call it A] automatically to today’s date when another field [call it B] is changed to 'Closed?" Additionally, i want to lock this from modification.
Create a action that sets the date field to Today() and then create a workflow for “updates only” with “if this is true” to [B] = Closed. If you intend to edit other things for this entry you might want to look at [_THISROW_BEFORE] = Open and [THISROW_AFTER] = Closed kind of expressions. Otherwise the date will be set to today everytime you edit something after the fact.
LinkedIn
Twitter
