Logo 
Search:

MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Calculated Column - Need to increment a counter

  Date: Sep 17    Category: MOSS    Views: 2340

I need to create a calculated column and need to check the values of other
columns and increment a counter. For instance, if columnA=1, increment counter
by one. If columnB=1, increment counter again. I've looked all over for the
solution and keep getting bad results.

Share: 

 

5 Answers Found

 
Answer #1    Answered On: Sep 17    

What about creating the calculated column as the sum of the other columns?

 
Answer #2    Answered On: Sep 17    

I need it to be conditional. Only in the case that columnA is equal to 1 do I
want to increment the counter. I can get it to work for one column, but I have
10 columns that I need to check, and possibly increment the counter depending on
the value. Is this possible?

 
Answer #3    Answered On: Sep 17    

Well, it would be a heck of a lot easier with a workflow, but let's see.

What is the possible value set of Column A (etc)?

 
Answer #4    Answered On: Sep 17    

Yeah, I realized that after I posted the question! Workflow is the way I did it.

 
Answer #5    Answered On: Sep 17    

Okay. It's a bit unwieldy, but it'll do the job:

=IF(ColA=1,1,0)+IF(ColB=1,1,0)+IF(ColC=1,1,0)+IF(ColD=1,1,0)

 
Didn't find what you were looking for? Find more on Calculated Column - Need to increment a counter Or get search suggestion and latest updates.




Tagged: