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,
Hi - I'm trying to sum the "Bill Check" column if "Receipt" is unchecked and "Revenue Check" is 0 (will be displayed as 0.00). When using the below formula, i receive the #UNPARSABLE error but i can't resolve the issue. =SUMIF(AND([Receipt]2:[Receipt]762 = 0, [Revenue Check]2:[Revenue Check]762, "0.00"), [Bill…
I have sheet that relies heavily on formulas and cell links to stay updated in real time. Recently the sheet was toggled with and no longer contains any of the cell links or formulas (only hard coded numbers). I do not know what every cell was linked to or its' formula. I tried to request a snapshot using the activity log…
I am trying to create a dashboard to see the status of my orders as well as how many orders total are older than 30 days at any given point. I have created charts to show the order status and stages they are in, but I cannot figure out how to show the total number of incomplete orders that are older than 30 days.
