Auto fill

[MG]

Hi- Can someone help me? I want to fill in the cells in the 1st column E.g. I want to reflect school 1 for all the stationary in 2nd column. Similarly, School 2 should get reflected against all the  stationary cells. Please refer the expected output in the next sheet in the attached file. Thanks in advance :)

[IraWatt]

Hey @MG,

You can use a multi row formula to achieve this:

IF [F1] =NULL() AND [F2] != NULL() AND contains([Row-1:F1],"School")  THEN [Row-1:F1] ELSE [F1] ENDIF

This formula is set to update F1 with the row above when F1 is empty and F2 is not empty and the row above contains School.

Any questions or issues please ask :)
HTH!
Ira

[IraWatt · Accepted solution]

In future best to post Designer questions on the Designer question board you'll get a quicker response 😄

[MG]

Oh Great! That's awesome! Actually I am new to this so not sure of the details as to where to post :) 

I had few more questions- 1. What if instead of text ("School"), there is 6 digit number, what should be written in the formula? 2. What if I want to remove the blank rows after each set (E.g. Row between School 1, School 2 and so on....)

[IraWatt]

Ah okay, for your first question you could use REGEX_Match([Row-1:F1], "\d{6}") this will look for 6 digits in the row above:

IF [F1] =NULL() AND [F2] != NULL() AND REGEX_Match([Row-1:F1], "\d{6}") THEN [Row-1:F1] ELSE [F1] ENDIF

to get rid of NULL rows theres a few ways to do that probably the easies is just to use a filter like this: