Forum Discussion

Copper Contributor

Mar 26, 2019

Excel progression tabs / wording

Hello community, I'd greatly appreciate a helping hand if possible! I have an Excel file with a vast amount of data, I have created separate tabs for work progression. In the first tab I hav...

excel

Formulas and Functions

Twifoo

Silver Contributor

Mar 26, 2019

What if tab 1 is workable, in progress, or blank?

Loobc
Copper Contributor
Mar 27, 2019
Twifoo Thanks for the response!

We use the status to give our figures each day, so preferably I'd like them to remain
- Twifoo
  Silver Contributor
  Mar 27, 2019
  If Work1 in Tab1 is Completed, Work1 in Tab2 is Workable. What I want to clarify are these:
  1. If Work1 in Tab1 is Workable, what will Work1 in Tab2 be?
  2. If Work1 in Tab1 is In Progress, what will Work1 in Tab2 be?
  3. If Work1 in Tab1 is Blank, what will Work1 in Tab2 be?
  - Loobc
    Copper Contributor
    Mar 28, 2019
    Twifoo I only need the completed in tab1 to show as workable in tab2, the other 'statuses' are not needed.
    
    Work1 Tab1 Workable, would show as Blank on Tab2
    Work1 Tab1 InProg, would show as Blank on Tab2
    Wark1 Tab1 Completed, would show as Workable on Tab2