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

Options
vsekuboy24116
vsekuboy24116 ✭✭
edited 12/09/19 in Archived 2017 Posts

Hi,

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?

Thanks

Vijji

Comments

This discussion has been closed.