When I do an Asana export (I used Velocity - super useful) some of my Project IDs look like this:
And some of my Task IDs look like this
Now for us, Project IDs = CLIENT IDs - and TASKS = PROJECTS for that client.
In the FORMULA bar I do see the right ID - it’s in the CELL that I don’t.
Copy format from a different cell doesn’t work I figured out that I have to add an ’ to the beginning of the cell, convert cell to plain text, and then I’m able to take out the ’ and it will “stick”.
What could be causing this?
Is this likely to be something purely from within the sheet or could something in Asana be causing it? I don’t see any patterns with the clients/projects or the tasks.