Search: | |||||

| ||||

Home » Forum » MOSS | RSS Feeds |

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.

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

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?

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)?

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

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.

Related Topics:

- Calculated Counter column in sharepoint list
- Forcing 'save as' if changes are made.
- Add link to 'my site' in 'save as' box
- Calculate column misssing in Total category
- Calculating average from column of multiple list
- Data connection to Infopath from a calculated column in Sharepoint
- Calculated Column issue
- Sum for Calculated Column
- Calculated column formula
- System generated columns are not seen while creating calculated
- Calculating column values from choice field
- Calculated Column question
- SPD Workflow - getting calculated value back into list column
- Calculated Column using =LEFT() formula
- Calculated Column for DIF
- Excel Formula in SharePoint Calculated Field/Column
- Calculated column - problem with formula
- Calculated columns
- Calculated Column - Count Text
- InfoPath and Calculated Columns
- Calculated Columns in Lists
- Using the file namd in a calculated column
- Calculated Column Output HTML
- Calculated Column Begin Event List
- Trying to create a sign-up list using calculated columns