On the Time Tracking form, we only want employees to see open projects in the list for the Project field.
Is there a way to filter the available values for the native Project field to only include Projects where Status <> Closed?
If the native field on the form can't be filtered, I'm working on a work around. I've created a custom Transaction Line Field that applies to Time. For Sourcing I have a filter for Status not equal Closed. This "Open Projects" field is working fine on the form. Only Open Projects appear in the list and can be selected.
Then I thought I could use a workflow to Set Field Value on the native Project field to the value selected in Open Projects. I haven't been able to get the Set Field Value action to work. Suggestions?
Thanks,
Chris