I am struggling to get a text value from a formula cast as a text in a text column.
See screenshot - text column called “Outlook TItle” need to mirror the formula column “Calendar Input fo..”. I run one automation but it thrown back a “null”.
This is the formula I used, and it is in action under formula column “Calendar Input fo..”. It is extract from “PO #” (text column), Contract Code (formula column), Initials (Mirror Column) and Interpreter Initials (Mirror Column" then insert a dash between them. If there are no value, it will add “tbc” (to be confirmed) in its place.
CONCATENATE(IF({PO}=“”, “tbc”, {PO}), “-”, IF({Contract Code}=“”, “tbc”, {Contract Code}), “-”, IF({Initials}=“”, “tbc”, {Initials}), “-”, IF({Interpreter initials}=“”, “tbc”, {Interpreter initials}))
I wonder if the use of mirror columns and additional formula column is upsetting the proceeding? I am really scratching my head here.
Basically, I want to create an integration with Outlook Calendar Integration Plus from Fantasy Media. And it seems all the mapped fields need to be in text - not read-only columns such as mirror and formula columns.
I have tried various apps that does the job of adding text from formula col based on certain conditions. It seems stubborn and won’t what it is being asked to do. Tearing my hair here over what should be seemingly a straight forward simple job.
