I am trying to make on cell value dependent on another cell value in the same row. I have a Project List spreadsheet with Data Validation list in column B with several Project Status (IE: Urgent, Active, Waiting for Client...) that I want to group together, but in a specific order, not just alphabetically.

I am doing this currently by having numbers (IE 01, 02, 03...) in column A in the order I want to group the rows, and organizing column A alphabetically when I am done updating the projects, but I have to remember to manually change the number in A when I change the status in B (I have the numbers white to be "invisible")

Is it possible to link the 2 columns, so that when I change the value in B, column A automatically updates? So, if column B lists Urgent, I want column A to say "01". B="Active", A="02". B="Waiting for Client" A="03" and so on?

  • Welcome. Please share a sample sheet with dummy data and desired results. – marikamitsos Nov 16 at 6:27
  • Sample data, desired output, current output or else trying to understand your problem is more difficult than the problem itself. – CodeCamper Nov 17 at 23:48
  • Attached Link is a blank copy of my file. I am trying to link columns A and B to change with each other. Right now I am manually changing both columns. docs.google.com/spreadsheets/d/… – Shaun Nov 18 at 15:19

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.