First Post -
I'm trying to fill Column C with a disposition for a request.
Right now, if the ship date is more than 45 days from today, column B supplies "N". If B is "N", I'd like to populate C with "Decline". If column B is "Y", provide a list for a table. Data Validation doesn't seem to like it.
Data Validation is =if(B2="N","Decline",List)
<tbody>
</tbody>
Thanks for your ideas!
I'm trying to fill Column C with a disposition for a request.
Right now, if the ship date is more than 45 days from today, column B supplies "N". If B is "N", I'd like to populate C with "Decline". If column B is "Y", provide a list for a table. Data Validation doesn't seem to like it.
Data Validation is =if(B2="N","Decline",List)
Ship Date | Within 45 Days? | Accept/Decline |
1/1/1988 | N | |
6/19/15 | Y |
<tbody>
</tbody>
Thanks for your ideas!