if-statement - Google Sheets Importrange statement in SWITCH
问题描述
I'm using the importdata
statement inside in Switch
condition and it does not return anything nor give an error.
My formula:
=SWITCH(C5,"Desired Value",IMPORTRANGE("url to the google spreadsheet", "MyTab!A:E"),C5,"Another Value","Another Value Output")
So when it's "Desired Value" is prints nothing.
If I write a separate IMPORTRANGE
without SWITCH
it works fine.
EDIT:
Example
Source File (from what I'm importing) link and the file with SWITCH statement link
解决方案
推荐阅读
- javascript - React Native - 子组件中的功能组件引用
- react-native - 如何获取存储在谷歌云平台存储桶上的图像?
- git - 使用 heroku 和/或 github 跟踪文件
- python - 为什么从 PyInstaller for Centos 创建的单个可执行文件必须从可执行文件上方的一个文件夹运行,即“dist”文件夹
- kubernetes - Kubernetes client-go:watch.Interface vs. cache.NewInformer vs. cache.NewSharedIndexInformer?
- node.js - 如何在项目中设置参数 NODE_EXTRA_CA_CERTS 而不是脚本
- python - AttributeError:“DecisionTreeRegressor”对象没有属性“r2_score”
- mysql - 更改 mySQL 中的字符集时出错?
- python - 网页抓取而不会被阻止
- r - 重复循环并在 R 中添加列