Forum Discussion
Katongo
Oct 31, 2021Copper Contributor
Data Validation with formula
Hi,
is it possible to have a non-drop down formula together a drop down formula in data validation "list"
Kind regards
2 Replies
- Juliano-PetrukioBronze Contributor
- KatongoCopper Contributor
Hello,
Thank you
In the attached file, I intend to have people on the sheet named "Already Reviewed Files" to be:
a)auto-populated on the sheet named "File Review Outcomes" under column H (File output) that has a data validated list [with a formula]
b) when auto-populated, their cell under column H (File output) should be locked to prevent data entry
King regards