business rule on 'Expected delivery date'

Garconbd

Hi,

In my smartsheet i need to set a rule like whoever fillit out the 'Expected delivery date' should show three days later from the current date. Like lets say I am filling out on 1-May-2024 , the 'Expected delivery date' should show 4-May-2024. The use should not able to choose any date before 4th may.

IS it possibe

Mark.poole

=[Created Date]@Row+3 in a date column

This will automatically do 3 days later as an expected Delivery date.

Garconbd

Hi, I am pretty new to smartsheet. when I am writing =[Expected Delivery Timeline]7@row+3, it is giving me error,#UNPARSEABLE.

Can you please elaborate ? FYI my [Expected Delivery Timeline] column is empty now.

Mark.poole

either remove the @row or the 7. The 7 means to look in the 7th row of the Expected Delivery Timeline column. The @row means to look at the same row of the formula. What column is your created date in? And what row are you wanted the created date +3 in?