Go 4 Sharepoint

Search:

Welcome: Guest!

MOSS Forum

Home » Forum » MOSS

Ask a question

RSS Feeds

Calculated Column - Need to increment a counter

Date: Sep 17, 2011 Category: MOSS Views: 106

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.

Tagged:calculated column need to increment counter

5 Answers Found

Answer #1 Answered On: Sep 17, 2011

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

Answer #2 Answered On: Sep 17, 2011

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, 2011

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, 2011

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

Answer #5 Answered On: Sep 17, 2011

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.

Your Answer

Answer should be atleast 30 Characters.
Please put code inside [Code] your code [/Code].

Please login to post comment

Previous: Document Library Field Querying by End User at 'run time' - Sharepoint 2010

Next: Joined Dataview Performance

Go4Sharepoint, is a Microsoft Featured Community. Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation. All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.