Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
need to populate the quarter based on the date
I've 3 columns - quarter, quarter beginning, quarter ending and populated these columns as follows:
Q4FY17, 30/4/17, 7/29/17
Q1FY18, 7/30/17, 10/28/17
Q2FY18, 10/29/17, 1/27/18
Now, in another sheet, I've a date column. I want to populated the quarter column in this sheet based on the other sheet - depending on the date. i.e., if the date is 11/20/17, it should automatically pick Q2FY18
Can someone please share a easy way to do this?