Formula to find the average word used in a column

Ann11

@Genevieve P. how do I do this?

"Adjusting the formula you have in the Rating column so it doesn't show a rating for that value, or returns "N/A" instead."

Genevieve P.

Hi @Ann11

This depends on how you fill in your Rating column! Is it a manual change? Or a formula?

If it's a formula, you would just need to add an IF statement in the front which says If the cell in the Title column is blank, return "N/A", like so:

=IF(Title@row = "", "N/A"

If it's a manual change, you could set up a Change Cell workflow triggered when a new row is added, then use a Condition block to check if the Title column is blank: Change the Value of a Cell in an Automated Workflow

Cheers,

Genevieve