Hello,
I am creating an Excel spreadsheet in Google Sheets.
I have one column that has numbers in it:
i.e.
1
2
1
5
The numbers represent fixes. When a fix is made, the number will receive a strikethrough in the cell.
I want the header for that column to read "x of 9 fixes remaining" where "x" automatically counts down when a strike through is applied in the cell. (i.e. When the first cell receives a strikethrough, it should say "8 of 9 fixes remaining".)
Please let me know if this is possible.
Thanks!
Bookmarks