I am trying to transform the data using Formula.
Creating Project Lifecyle in table by accessing the value from Acme Project Status.
The formula I used is =Lookup(Project Name,Acme Project Status,Project Name,Project Lifecycle).
Column gets created but the data is not getting linked for some reason.Getting a : on all columns as output.
I am thinking Project Lifecycle is the appropriate field but tried with State as well but getting output for only 2 rows and the rest is : again.
Is this really critical to get rectify to get the output? Is this a known error or am i doing something wrong?
Please let me know.