Get instant live expert help on I need help with google sheets data validation custom formula
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
How do I filter for multiple custom values in Google Sheets?
Solved by O. J. in 23 mins
I need to apply "=IF(O3="X",'Data Validations'!$C$2:$C$7,'Data Validations'!$C$8:$C$13)" this statement in google sheets data validation
Solved by Z. Y. in 22 mins
i need help with a custom formula in google sheet
Solved by F. J. in 17 mins
Fixing Formulas DESCRIPTION: MY QUESTION IS ABOUT: Fixing Formulas DESCRIPTION: I need to apply "=IF(O3="X",'Data Validations'!$C$2:$C$7,'Data Validations'!$C$8:$C$13)" this statement in google sheets data validation
Solved by A. S. in 30 mins
I am having issues with using Custom Data Validation to limit the user input in the following way: Tab 1 has a list (part of a table) on it with a number of text items, as well as 5 cells which are set to be equal to the user input from Tab 2. In Tab 2, I want to use custom data validation to prevent the user input from being equal to anything in the list in tab 1. I am currently trying to use =countif([list from tab 1],[user input from tab 2])<=1 as the formula but for some reason it isn't working. I know the formula is right because I tested it outside of data validation and it works. Does Custom Validation have a bug!?
Solved by D. D. in 28 mins