AnsweredAssumed Answered

I want to set a field value (choice column) based on if other fields are selected.  I have a few date fields and a few checkboxes that, if selected, I want them to automatically populate the choice column (it's the issue status).

Question asked by laureneibarra on Feb 13, 2017
Latest reply on Feb 23, 2017 by rhia

I want to set a field value (choice column) based on if other fields are selected.  I have a few date fields and a few checkboxes that, if selected, I want them to automatically populate the choice column (it's the issue status).  How do I keep from one from overwriting the other?

 

For instance, I have the choice column automatically default to a certain status (pending), then when one group works on it and enters a date in a certain field, the status should change (scheduled).  Then, another group will work on it and update either a different date or check a box (completed date or a choice of checkboxes why it was unable to complete).

 

My problem is, how do I make sure that the status doesn't revert back to a scheduled status?

Outcomes