Forum Discussion
AdamKeever1
5 years agoQrew Commander
I would suggest you add a third rule to protect the initial result:
You may want to add a formula field for current status. Something like this:
If (
[Field 1] = "" and [Field 2] = "","",
[Field 1] = "No" and [Field 2] = "",[Field 1],
[Field 1] != "" and [Field 2] != "",[Field 2],
)
------------------------------
Adam Keever
------------------------------
You may want to add a formula field for current status. Something like this:
If (
[Field 1] = "" and [Field 2] = "","",
[Field 1] = "No" and [Field 2] = "",[Field 1],
[Field 1] != "" and [Field 2] != "",[Field 2],
)
------------------------------
Adam Keever
------------------------------