Form rule doesn't trigger when uploading data
I will be uploading data from a spreadsheet on a daily basis. I have a rule set to recognize if specific data is in a specific field and if it is check a specific box. For instance: If [Subject Prefix...
Forum Discussion
A formula would be your best bet here. Way simpler and more reliable and foolproof than actions.
I would make a formula checkbox field called [Resolved (final)] and a field called [Resolved Override] with Yes and No as choices
If(
[Resolved Override]= "Yes", true,
[Resolved Override]= "No", false,
Contains([Subject Prefix], "RE:"), true)
That will let you override if you need to else fall back to the contains formula.
I would make a formula checkbox field called [Resolved (final)] and a field called [Resolved Override] with Yes and No as choices
If(
[Resolved Override]= "Yes", true,
[Resolved Override]= "No", false,
Contains([Subject Prefix], "RE:"), true)
That will let you override if you need to else fall back to the contains formula.