John, I can't get your calculated field working either. Honestly don't know how it's working on your side. For my side, what does work as a calculated field is the following:
IF(ARRAYLENGTH(ARRAY({DE:Fruit},", "))>1&&
CONTAINS("Tomato",{DE:Fruit}),"Tomato must be the only contract selected. Adjus...
Got it, so you have the calculation in a calculated field, and it works there, but it doesn't work when you paste it into a validation logic statement. And then, do I have the understanding right that if I have a field, "Fruit" and options are "apple", "peach", "tomato", you want to write out some v...
I'm curious if you saw or not -- the certification links should all contain a practice exam, and exam prep guide. If you didn't, these are generally speaking, a good place to start.
sorry, I'm not clear. Are you saying it's a valid expression because it didn't error, or are you saying "I tested it out as a calculated field, and it gave me the results I'm looking for"?
The exists webinar will really help then. Super easy 8-step instructions below.
1) Pull up a task report and set up the filter you want:
* actual completion date past month
* task name contains ABC
* whatever else you normally put in that is task related, like status not cancelled, or etc.
2) sw...
Just a guess:
if the approval process is on the task's "complete" status, what would you think about just searching for projects where the task's actual completion date is in the past month?
i.e. when a task is completed, does this trigger the correct actual completion date? (is the actual complet...