Sign in to join the conversation:
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,
Hi, how is the strikethrough being applied? via Conditional formatting or manually?
Mick
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
That would be my suggestion too, nice one Mike,
I know I'm going to kick myself when this gets resolved, but I'm having a bit of a brain fart right now. I'm trying to get the lowest non-blank value in a particular range (columns A-E). [A]@row=18, [B]@row=16, [C]@row, [D]@row, & [E]@row are all blank. All five rows are products of column formulas. Basically, there are a…
I am trying to have the Drop Dead column subtract 42 days from the Final Confirmation Date. I have the Drop Dead column setup as a Date Column and have tried doing this formula, but am getting an "Invalid Operation" error. Can anyone tell me what I am doing wrong? And thanks in advance.
I am wanting to have a sheet that is going to have all of our production records on it. The office manager will enter all of the work order information with 1 form, and someone in Quality will enter the measurements on another form. If I have the Primary Column as each part's serial number, will the measurement info be…
