Read time: 4 minutes
Raise your hand if you’ve ever:
Received a bunch of random employee IDs to pull some data for.
Proceeded to run and download a big report with a lot of stuff you didn’t need.
Messed around with VLOOKUP/HLOOKUP/XLOOKUP/WHATEVERLOOKUP to stitch two files together to get what you did need.

Wow, who would’ve thought! 😜
Now, it’s one thing if it’s You, the Workday Wizard LOOKUP Aficionado™ catching these requests, but imagine what happens if some of ‘em land on the desk of your less… technologically endowed colleagues 🫣
Wouldn’t it be nice if, instead of all that hoopla, anyone could simply paste the list of EEIDs straight into a report prompt and get exactly what they want in 2 clicks? 🥹
Fortunately, there’s a way to do exactly that, using a neat reporting trick.
A severely underrated calc field type, Prompt for Value (PV) lets you add a prompt to your custom reports for pretty much anything (including parameters in nested calcs), making your reports much more sustainable, scalable, automated, and elegant 💅
(For more info on this CF type, check out our full breakdown here.)
In this issue, you’ll use it to create a powerful text-based prompt that can filter for a list of Employee IDs directly.
Let’s dive right into our use case! 🤓
This is where the good stuff lives.
Free builds awareness. Premium fills all the gaps 🦄
Below:
Build the Prompt for Value calc field in less than 30 seconds
Add it to your report filter with the right OR or AND setup to make it optional or required
Hand stakeholders a report they can run themselves: paste, click, done
Plus everything else in Premium:
⭐️ Release Ratings & Reviews
🔐 Full archive access
🗳️ A say in what gets built
Written by Dániel Cseh , Resident Writer at Well Built — HRIT Manager and foosball enthusiast from Budapest. Writes Well Built deep dives that make scary Workday config feel doable. Read more from Daniel on Well Built.


