MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

Calculated Column - Need to increment a counter

  Date: Sep 17    Category: MOSS    Views: 2303

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.



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:


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.