We have a need similar to this person’s idea (below). Our issue is that we want to reflect the end date of the project in multiple places since we have a finance board, a grant board, and the project board.
We have a “Date Delivered” field which is set up as a date field on a project. We also have corresponding data fields (client-requested) for Fiscal Year, Fiscal Month, Fiscal Quarter, etc.
Is there a way to have Asana deduce or extract the component pieces of a date and apply those pieces into other fields? -OR- Does Asana offer a native dashboard module which can analyze a date based on certain criteria (as Excel does)?
Ex.: Date Delivered = 7/4/2023; Can Asana auto-populate FY as 2023, FM as July, and FQ as Q4?