Thank you for your response, while we do use the custom prompts for other reports in this use case there are just way too many possibilities for them to be pre-configured. We were trying to achieve something similar to the WF search box but within a report so that users can se relevant data rather t...

The report we have will always use contains as the prompt option, having all the other options is an unnecessary extra click to the user experience. Is there a way to disable the other options for a prompt?

Thanks for sharing!

This can be done using EXISTS filter, here is what we use for Proof Approval report:EXISTS:a:$$OBJCODE=DOCUEXISTS:a:project:status=CUREXISTS:a:project:status_Mod=inEXISTS:a:versions:ID=FIELD:documentVersionID You might have to play around a little to get it to work with Document Approval report but ...

Hi Nichole,Is there a way to extend this to only consider working days based on a schedule in the system? Just counting the working days rather than all weekdays?

I am trying to add a calculated field that removes dashes from another field value, I was thinking it would be just as straightforward as:REPLACE(FIELD,"-","")But doesn't seam to work. It does replace the dashes with a letter or a space when the same is added as the third string:REPLACE(FIELD,"-","a...

Add a "Section Break" above the fields you want to hide and set edit for that section to Admin only. If the reports would be shared with general users, in the View section you might want to add their access type to the object. If not then keep that as admin only as well.

Haven't used MM fields but if you are trying to filter for only projects with a specific role/individual assigned to a task you might be able to achieve that with the following filter: tasks:roleID={roleID}tasks:roleID_Mod=inORtasks:assignedToID={userID}tasks:assignedToID_Mod=in If you're just tryin...

You can create a User report with all the required fields and then add that to a dashboard. Update user layout templates and add a custom tab to "When a person with this Template looks at: A Project"

Hi Stephanie, That worked! Thank you so much for sharing this!! Surya Laani Scholastic