SOLVED

# Count - simplified for added columns

Copper Contributor

# Count - simplified for added columns

I created a count formula for uploaded date to give a version number but we add columns as more edits are made.

I am currently adding a new section to the formula when we add a new column.

Is there a way to simplify it so its shorter and doesn't require editing:

=IFS(COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=0,"None",COUNT(J2,N2,L2,M2,#REF!,O2,P2,Q2)=1,"V1",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=2,"V2",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=3,"V3",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=4,"V4",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=5,"V5",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=6,"V6",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=6,"V6",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=7,"V7",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2)=8,"V8",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2,R2,S2)=9,"V9",COUNT(J2,N2,L2,M2,N2,O2,P2,Q2,R2,S2)=10,"V10")

best response confirmed by Laura Backshell (Copper Contributor)
Solution

# Re: Count - simplified for added columns

@Laura Backshell don't understand why you would address every single cell in a closed range. And you have duplications in there as well. Is that intended?

I you just want to count the number of numeric entries in a range and add the letter "V" in the beginning use:

``="V"&COUNT(J2,L2:Z2)``

and make the range L2:Z2 large enough so that you can enter more versions later on. "V0" would mean "None".

If returning "None" is important, than you could use this:

``=IF(COUNT(J2,L2:Z2),"V"&COUNT(J2,L2:Z2),"None")``

1 best response

Accepted Solutions
best response confirmed by Laura Backshell (Copper Contributor)
Solution

# Re: Count - simplified for added columns

@Laura Backshell don't understand why you would address every single cell in a closed range. And you have duplications in there as well. Is that intended?

I you just want to count the number of numeric entries in a range and add the letter "V" in the beginning use:

``="V"&COUNT(J2,L2:Z2)``

and make the range L2:Z2 large enough so that you can enter more versions later on. "V0" would mean "None".

If returning "None" is important, than you could use this:

``=IF(COUNT(J2,L2:Z2),"V"&COUNT(J2,L2:Z2),"None")``