What is the goal of your workflow? What problem does it solve, or how does it help you?
I figured out a way to have the Data Validation dropdown hide values that have already been selected, without putting the red error mark in the corner of the cell.
This could be useful, for example, on the Accounts sheet. Rather than having to check which accounts you’ve already selected, it could filter them automatically in the dropdown.
This is a tool for google sheets, not Tiller Money specific. But I figured it might be useful for those here who are developing templates. Maybe other people have already figured it out, but I couldn’t find it anywhere online so I decided to share it.
Please describe your workflow. What are the sheets? Does it use any custom scripts or formulas?
The linked sheet below explains it, it’s not a complex sheet just a demo of how it works. I figured it would be easier to show rather than tell. There are no custom scripts or formulas.
Is it ok for others to copy, use, and modify your workflow?
If you said yes above, please make a copy of your workflow and share the copy’s URL:
Data Validation - Hide Selected