sorry to say that it sounds like your gearbox has went, could be the torque converter, could be the oil level or the filter, could be the switch or control valve.
very common fault, the boxes really are s***t and the reason I ended up selling my rs6.
the car had £12k spent on gearboxes and...