Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying to get data from 2 columns and put the data into a new column depending on the criteria/status from another column:
Example:
Column 1 - Status
Column 2 - Budget Hours
Column 3 - Delivered Hours
Column 4 - NEW Column
If the status in column 1 was "Delivered" or "Closed" or "Historic" I would like the NEW Column to pick up the hours in column 3. If the status in column 1 was "In-Progress" or "Reserved" I would like the New Column to pick up the hours from column 2.
Can anyone help with the coding for this?
Thanks.
please don't create multiple threads for the same question:
Bringing 2 columns of numbers into a new column depending on criteria
thanks
regards
Marco