Dates Column Rule

AndreMenezes

Hey Team,

How can I build a rule to determine Start and End dates? I have these columns in my Grid, Start and End dates, but I also have a column called, Quarter. I want to build a rule saying that, when the user fills out the column Quarter, the start and end date columns are automatically filled out. Is that possible? 

Thanks in advance

Paul Newcome

You would use nested IFs.

=IF(Quarter@row = "Q1", DATE(yyyy, mm, dd), IF(Quarter@row = "Q2", DATE(yyyy, mm, dd), IF(Quarter@row = "Q3", DATE(yyyy, mm, dd), IF(Quarter@row = "Q4", DATE(yyyy, mm, dd)))))

Paul Newcome

You would use nested IFs.

=IF(Quarter@row = "Q1", DATE(yyyy, mm, dd), IF(Quarter@row = "Q2", DATE(yyyy, mm, dd), IF(Quarter@row = "Q3", DATE(yyyy, mm, dd), IF(Quarter@row = "Q4", DATE(yyyy, mm, dd)))))

AndreMenezes

Hello Paul,

Thanks a lot, but it did not work, not sure if I am doing something wrong, see below. I am receiving the error, #INVALID COLUMN VALUE

AndreMenezes

Paul,

It worked now. The column was not defined as a date.

Paul Newcome

Happy to help. 👍️