A: Yes, you could ask the AI to create a formula for a specific task.

As for connecting a column from one sheet to another, I am not sure. I'd probably bring the data in from that other sheet into a new tab on the same sheet so it's all within one Sheet to avoid any issues

Best,
Curran