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've had a sheet set up where once the form is filled out an automation will create a PDF and then from there is will send out an email alert to the designated email box. The alert includes and documents that were uploaded during the form being filled out and the PDF that the Smartsheet creates. Its been doing this fine…
Hello, I am trying to use the IF formula to perform a date calculation based on a value selected in another column but keep getting UNPARSEABLE error. Here is the formula that I have used. I have also pasted the screenshot for reference. Can anyone help me out on this? =IF([SLA]@row = "Standard",[Feasibility_Start…
Hey, I've gotten some fair formula experience over the last year (mostly through googling and this searching this forum) but hit a brick wall with my latest ambition… I have a smartsheet in Gantt mode tracking events and sizes relating to the event. I'd like to be able to use a date picker in the summary tab to pick a…
