In a Google Sheets, I have a Results main sheet, and the Details sheet.
I would like to modify the Details and see the Results changing.
Is it possible to split the view between two sheets in the same browser window?
Google-sheets – Google Sheets, view two sheets side by side
google sheets
Related Solutions
Visit a site like http://whatsmyua.com using your mobile browser and note your User Agent string.
Use a FF add-on such as User Agent Switcher to modify your UA to exactly match that of your mobile browser.
Try opening the page and see if you get the mobile version.
You can use a quite pragmatic approach to reach your goal.
Formula
=ARRAYFORMULA(
SPLIT( // string
REGEXREPLACE(
A1:A4, // text
"[users,<=>compani]", // regular_expression
"" // replacement
),
" ") // delimiter
)
copy/paste
=ARRAYFORMULA(SPLIT(REGEXREPLACE(A1:A4, "[users,<=>compani]",""), " "))
Screenshot
Explained
The regular_expression is cleaning up the string, in preparation for the SPLIT. The replacement is simply set to contain an empty string. The result, yields a string that contains one or two values, separated by a white space. The delimiter in the SPLIT is set accordingly and all is put into an ARRAYFORMULA.
Related Topic
- Google-sheets – Does Google Sheets have sheet-level named ranges
- Google Sheets – Function Name to Add Rows
- Google Sheets – Viewing the Same Data in Two Views
- Google-sheets – Partial cell formatting with CONCATENATE in Google Sheets
- Google-sheets – Split Master Sheet into Multiple sheets
- Google Sheets – Fix Date and Time Formatting with Google Apps Script
Best Answer
Unfortunately you cannot split the view between two sheets in the same browser window.
As a workaround though, you can use
INDEXand place the content of the ranges you need fromResultsto columns next to your content in yourDetails(This is just one way. There are more depending on the situation.)