I have a column as Planned Timeline in Portfolio Board where the dates are pulled from other project Boards. I used below formula to convert the Planned Timeline column to quarter based column, unfortunately its not working. but when i use a timeline column from a portfolio board itself ,then its working. (my data source for planned timeline is coming from other project boards).Is there way to work on this.
IF({Planned Timeline#End},“Q”&FORMAT_DATE({Planned Timeline#End},“Q-Y”),“”)