How do I follow a sequence in Google Sheets?
This is purely an example, I have no code and have been doing things entirely manually. What I would like to do is follow a certain sequence by inputting a text and the next cell automatically guessing what comes next. I attempted with IFS in another sheet while referencing the original one so I could still input text in the ones being modified (if that even makes sense) and it didn't work,,, I only know the basic of the basic, so any help would be immensely appreciated. (sequence is w/g/m > x > w/g/m > x > w/g/m > x > house)