Restrict Date column Based on another date column

Mashael

Hello Everyone,

I have two columns: Entry Date and Execution Date.

I am trying to restrict the Execution Date to allow only date values that are after the date of the Entry Date value.

for example:

For Entry date, the value is:1/1/2023

The Execution Date: should only allow dates that are after 1/1/2023.

is this possible?

Paul Newcome

You will not be able to restrict date selection, but you can add a flag type column with a formula to flag rows where the date is invalid and have an update request sent to the user.

Mashael

thank you so much for replaying!

Can I please know how to add a flag to my date column?

I am fairly new to smart Sheets, if you can provide me with some details, I would be so grateful!

Thank you

Paul Newcome

You would insert a new column set as a flag type (found in the checkbox type column settings) and use a formula in it to compare the two dates.

=IF([Execution Date]@row<= [Entry Date]@row, 1)