Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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,
Does anyone know how to revert a sheet to a prior version after a column formula resulted in replacing all of the values with #circular reference? Would all entries have to be manually re-entered?
I know you can use a formula like this: =[Projected Payment Milestones (+)]@row to copy the "value" from one cell to another (because that cell is a formula); however, I need just the "value" formatted as a number ($) to be copied; because in my REPORT I am not able to edit the data as it is recognized as a FORMULA (fx) Is…
I need the Date of Sample Shipment to start within 20 days of the Date of Manufacturing Start Date. However, the predecessor I have there isn't working properly. What should it be? Thank you so much
