How to create a new column and add an identifier after a certain word is reached

[jillian]

Hi! If I have the data below, I want to write a formula that adds an identifier in a new column after the word "Total" is reached. The formula will add the word "Delete" next to Total, 100, and 200. How do I do this? Thanks!

Account

1

2

3

4

Total

100

200

300

[Thableaus · Accepted solution]

Hi @jillian 

Would something like this work?

Using Multi-Row Formula.

You can group by some field if you need to, if you have multiple totals.

Cheers,

[jillian]

@Thableaus Thank you!!