Reference a cell on another sheet based of a value in the current sheet
Hi Smartsheet hive mind. Hopefully someone may be able to answer this question. I have a sheet (Sheet A) that will be tracking tickets and will have the dates the ticket was created on it. I have another sheet (Sheet B) that has every date of the year on it but another column that tells what the fiscal month is (in this case the 29th -28th). Is it at all possible to have a column in sheet A (Fiscal Month) reference the fiscal month on sheet B when a new date is added to the Ticket Creation Date column in sheet A?