Text to quarter ?

ILYAS

Hello Everyone,

what is the best formula that we can use to go from this to this:

Txt Period "Format Text" (Example: Q1 FY24) ===> Quarter "Format Quarter" (Example: Q1 FY24)

SriNitya

ILYAS
Hi,
Text - Time Period → Use FINDITEM.
FINDITEM(TIME, Text) Format line Item as Time Period: Quarter.
let me know if it helps.

ILYAS

Yes it works thank you so much