I am using google Forms to send information to google sheets. I have a number of sheets that I have built that send information to the main sheet. I want to use an IFS statement, but I cant get the value of the sheet I am working on to have the correct text, because I am copying the text from a separate sheet Example (='(1)Qualification Call'!C178). Sorry..really hard to explain what I am doing by text
Solved by T. H. in 12 mins