Count values that are not formatted with Strikethrough

cseelbach27

Hello - -

I am trying to count the number rows in a column that do not have strikethrough applied to them. Is there anyway to use a formula to determine if a cell value has been formatted with strikethrough?

 

Thanks,

Mick Jordan

Hi, how is the strikethrough being applied? via Conditional formatting or manually?

Mick

Mike Wilday

If your strikethroughs are being applied manually then you there isn't a way to count those rows. I would suggest adding a checkbox for determining if you want a row striked-through. Then you could set up conditional formatting on that checkbox... if its checked - show the row striked through. Then you could set up a countifs statement and count all the boxes that are checked/displaying with strikethrough. 

https://help.smartsheet.com/function/countifs

Mick Jordan

That would be my suggestion too, nice one Mike,

Mick