How do I do have multiple conditions for data validation in a table?

Our take

To set up data validation for your Excel table that ensures a "Submit Date" is both after the "Open Date" and that the corresponding project number starts with the "PROJ" prefix, you can use a custom formula. In the data validation settings, you can create a formula that combines these two conditions. For the "Submit Date," use `=AND(Log[SubmitDate]>INDIRECT("Log[OpenDate]"), LEFT(Log[Proj#], 4)="PROJ")`. This will guide users to submit valid project numbers while ensuring the correct date sequence.

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:

https://preview.redd.it/5kwv6ekeo7yg1.png?width=210&format=png&auto=webp&s=bafbce2702829d1a9c33ef935280ab95faa71f19

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.

submitted by /u/AnonAMouse100
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

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