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?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!