I`m working on how to get the output of the filtered total value in Column1 and Column 2 and show it in Column 3. Example for better understanding -

**Column 1          Column 2    Column 3 (calculation)**
Complete            period 1    
Not Complete        period 2
Complete            period 3
Complete            period 3
Not complete        period 1

Column 3 to pull the total count of Column 1 with value set to Complete along with column 2 with value set to either Period 1 or Period 3.

I guess this can be achieved using Calculated column formula in Column 3. Please assist.

  • Can you copy/paste your columns one more time and enter the values you would like to see in column3, your description of column3 leaves for interpretation – Danny '365CSI' Engelman Jun 20 '16 at 8:47
  • @danny thanks for inquiring. If column 1 shows complete along with column 2 as period 1 or 3, then vased on the 2 conditins column 3 value to be 1 for that particular row. – Jason Jun 20 '16 at 8:53
  • Show us the column.. I am a programmer and able to interpret your text in at least 5 ways (3 of which stupid ofcourse) IE. My first thought was: 1 , 1 , 2 ,2, 1 in column 3 – Danny '365CSI' Engelman Jun 20 '16 at 8:56
  • Whether you want to iterate over all items or not, you can not reference complex fields like Lookups in a CC. You could get the values with code: sharepoint.stackexchange.com/questions/128479/… – Danny '365CSI' Engelman Jun 20 '16 at 9:02
  • @DannyEngelmanMPW please find screenshot for better understanding. kindly assist, i`ve researched a lot but cant find any rule that would allow conditional formatting to work using calculated columns formula. url: imgur.com/4Owv8kt – Jason Jun 20 '16 at 12:26

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.