I have A and B sheets in the same spreadsheet.
4th row of B sheet CT: If there is a value within the CZ range
I would like to reflect that data in the AG of the A sheet.
= IMPORTRANGE ("Spreadsheet Key", "B! CT4: CZ4")
I can get the range data of another sheet with the importrange function, but in this case I will get the data within the range, so if there is data, I want to display it in only one cell (AG4).
If anyone knows, please let me know.
Answer # 1
If there is only one value in the range, you don't have to worry about the delimiter, so let's integrate the range with TEXTJOIN.
If all are blank, blank will be returned.
= TEXTJOIN (, TRUE, IMPORTRANGE ("spreadsheet key", "B! CT4: CZ4"))
- google spreadsheets - i want to add data to the row with the latest value in a duplicate and unique column in a spreadsheet func
- python - how to put a value in the queue from within the asyncio threadpoolexecutor method
- i want to use the google spreadseet function to copy a value from one cell and place it in another cell
- google spreadsheets - spreadsheet with single quotes
- google apps script - get the value of a specific column in a gas updated row and send an email
- google sheets - extract if there is a character in the spreadsheet that matches the list
- mysql - if there is no sql value, i want to fill it with an earlier value
- vbscript - is there a way to get the return value by launching an application created in vbnet from vbsctipt?
- google apps script - if there is no reference value, the processing of the for statement will be interrupted
- i want to get the value from each cell of the table with google apps script
- google apps script - i want to display the value of the specified range on the sidebar with gas of the spreadsheet
- google sheets - i want to refer to the value of another sheet in the conditional format of the spreadsheet
- is the value within the specified range of the c# array
- google apps script - i want to add the value of gas specific column to a specific cell of another sheet as a memo
- google apps script - i want to retrieve the json value with gas, but i cannot retrieve it properly
- google spreadsheets - i want to aggregate from multiple sheets using the sumif function
- ruby - is there a way to use the value (variable data) in another class that has no inheritance relationship?
- google apps script - in gas, i want to set the value (check box) of the cell in the condition range to false by triggering the v
- google - i want to paste the gas value to the last line of the copy destination sheet
- python - you may need to restart the kernel to use updated packages error
- php - coincheck api authentication doesn't work
- php - i would like to introduce the coincheck api so that i can make payments with bitcoin on my ec site
- [php] i want to get account information using coincheck api
- the emulator process for avd pixel_2_api_29 was killed occurred when the android studio emulator was started, so i would like to
- i want to call a child component method from a parent in vuejs
- python 3x - typeerror: 'method' object is not subscriptable
- dart - flutter: the instance member'stars' can't be accessed in an initializer error
- xcode - pod install [!] no `podfile 'found in the project directory