Mysterious strikethrough being added during automation process?

Carly Chaput

Sheet 1: team manually enters weekly updates to dates and metrics

Sheet 1 Automation: weekly Friday morning trigger to copy all rows (~5-15 rows) from Sheet 1 to Sheet 2

Sheet 2: ledger of all updates made week to week

Report: Pulls in Sheet 2 from 12 projects, displays 8 columns, filtered down to just the prior 2 week's dates and metrics.

The Issue: When rows get to Sheet 2, for about half of the projects, everything copied over has a strikethrough that then shows up in the report as strikethrough.

I've already checked: Sheet 1 and Sheet 2 are identical across all programs with identical conditional formatting and identical automation. No where in Sheet 1's conditional formatting is anything set to "strikethrough". The automation is the only automation on these sheets and it's minimal, just copy rows to Sheet 2 on Friday mornings, no other changes. No conditional formatting is applied in Sheet 2.

Yesterday, Thursday, I manually went through and highlighted every column on both Sheet 1 and Sheet 2, clicked on and off the strike through to ensure NOTHING had strike through on it, double checked conditional formatting and automation, no strike through anywhere for any reason. Today, Friday morning, after the automation ran, half the rows copied over with strike through.

I am at a loss as to what else to look for and how to get the strikethrough to stop appearing, does anyone have any suggestions?

Georgie

Hi @Carly Chaput,

That sounds like very strange behaviour! I’ve not come across that before. One other thing you can check is the activity log in sheet 2, to see if you can see what has caused the strikethrough, or if the log only shows that the automation has run.

Since you’ve checked the formatting and conditional formatting in both sheets already, if the activity log doesn’t help, I’d recommend submitting a Support ticket to have the relevant team investigate this further. If you can provide the following details when submitting the ticket, that will help them to take a closer look:

• IDs of sheets affected (if this is affecting many sheets, provide the IDs of an example sheet 1 and sheet 2) -  open the sheet and click File > Properties to find the ID
• Screenshots showing:
  • Formatting settings for affected cells/columns on sheets 1 and 2
  • Conditional formatting rules on sheets 1 and 2
  • A view of sheet 2 after the automation run, showing the strikethrough

Thanks,

Georgie