Replacing nulls with values from other cells dynamic

[dianastate]

Hi!

I would need some help replacing the Null with the values from other cells.( i.e. to have FA23 in the entire column)

Some context: the values from the same column they have to be all the same. However, they change when I upload/refresh the data.

For example: I need to have "FA23" everywhere, but I don't want to put a formula with the specific words "FA23".

I need it to be dynamic, such as for the next time I am running the workflow ( i.e. when the season changes to HO23), not to change the formula.

I have attached a screenshot.

Thanks!

[FinnCharlton · Accepted solution]

Hi @dianastate , here's a way to do it:

We take the maximum value from the 'Season' column (which will be the non-null value). We then append this to the original data. Hope this helps!

[Rlopez21]

Thank you @FinnCharlton that solved an issue I was having as well!