Hi,
Need your help with creating an easy formula that return the quarter from the time line column.
for example:
timeline = 1 OCT 2021 until 31 OCT 2021 >>> Q column = Q4-2021
timeline = 1 OCT 2021 until 31 FEB 2022 >>> Q column = Q2-2022
Here you go:
IF({Timeline#End},"Q"&FORMAT_DATE({Timeline#End},"Q-Y"),"")
Jim - The Monday Man channel
Signup for a FREE Integromat account with this link and get a FREE hour with The Monday Man
1 Like
Its great!! Thank you!
It’s great!!! thank you!
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.