
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 21, 2023 02:47 PM - edited ‎Nov 21, 2023 02:48 PM
Hello,
Want to strike through text in a cell if a given string is found in another cell in that row. Is this possible?
The cell whose text I want to strike through is already a concatenation of various other field values. It's looking in a different field for the term "OMIT", and if that is found I'd like the text strike-through'd.
The "OMIT" will be searched for in a single select field, but I don't think that matters since I've already successfully searched for and IF'd stuff based on single select text contents.
TIA for any assistance.
Solved! Go to Solution.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 21, 2023 09:05 PM
This would be tricky to do. The only field type that can show strike-through formatting is a long text field with rich text turned on.
Airtable also cannot use formulas to format text. It's not like a spreadsheet.
There might be a way to have an automation that manually adds the markdown for strikethrough to the text, and then copies that markdown text to a rich text field. But whether this works really depends on your workflow and the number of automations you have, and how changes are entered. Really, too many variables.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 21, 2023 09:05 PM
This would be tricky to do. The only field type that can show strike-through formatting is a long text field with rich text turned on.
Airtable also cannot use formulas to format text. It's not like a spreadsheet.
There might be a way to have an automation that manually adds the markdown for strikethrough to the text, and then copies that markdown text to a rich text field. But whether this works really depends on your workflow and the number of automations you have, and how changes are entered. Really, too many variables.

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Nov 22, 2023 06:19 AM
That's a drag but makes sense. Thank you for your help.
Front-end issues are obviously not taken seriously; looking forward to updates.
