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 all. I'm trying to do something that I'm not sure if it's possible or not. We have a sheet that we are importing where the first column lists areas within our factory. Each column after that has a column name of a date. So 12/15/2025, 12/16/2025, 12/17/2025, etc. In each of the date columns is a target production…
Hello! I have what is probably a simple question my brain is just not comprehending properly. I need to SUMIFS from a sheet that matches some specific criteria but one of the fields I am using against needs to calculate a total if one dropdown field matches ANY ONE of these 3 items that is in it to be chosen… Capitol…
Hello, I have a checkbox column that I would like to be checked when comparing 2 columns. I would like it to be checked if the 2 columns are not equal or if one of the 2 columns has an error. It's important to note that both columns are numbers. My original formula was: =IF([COLUMN A]@row <> [COLUMN B]@row , 1, 0) However,…
