•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
How do I do have multiple conditions for data validation in a table?
I made an excel database, formatted as a table. The intent is to track how long a project is in the idea stage and then how long the project takes to get to the kick off stage:
| Proj# | OpenDate | SubmitDate |
|---|---|---|
| IDEA2 | 3/24/26 | |
| PROJ45 | 2/24/26 | 4/15/26 |
| PROJ24 | 12/24/25 | 4/1/26 |
When a project is submitted to the committee (the SubmitDate) it gets a project number, denoted by the prefix PROJ. Here's the problem I have. I need to restrict the Submit Date to be both AFTER the Open Date AND have the "PROJ" prefix in Proj# column. (When an Idea is submitted, the user just overwrites the IDEA to PROJ.) For the data validation I have been using the date validation greater than or equal to =INDIRECT("Log[OpenDate]") but I have no idea how to account for the prefix issue. Can anyone help? Thank you.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#Excel compatibility
#Excel alternatives
#big data management in spreadsheets
#conversational data analysis
#rows.com
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#data validation
#Excel
#table
#project tracking
#SubmitDate