Sign in to join the conversation:
Hello!
I'm trying to use this if statement:
=IF(OR([1]67:[30]67 = "R13"), "500", "")
But it's not working when I want it to check the whole row ([1]67 through [30]67) for R13. Is there another way for me to do this statement?
Thank you!!!
Well... since IF formulas don't usually check ranges what about using the Countif formula integrated into an IF statement
Try this... =IF(Countifs([1]67:[30]67, "R13") > 0, "500", "")
Also, by putting 500 in quotations you are turning the integer into a text format. If you are using that amount as a number you can remove the quotes like this.
=IF(Countifs([1]67:[30]67, "R13") > 0, 500, "")
This will count if there are any occurrences of R13 and return how many. If that number is greater than 0 then you will return 500.
Completely understand, thank you so much for your help!
You're welcome! Glad I could be of assistance.
Some of the APIs inexplicably don't seem to be working. For instance, I can make a request to the Get sheet endpoint fine, but when I try to List columns with the exact same variables I get a 404 Not Found response (see attached screenshots). Have encountered this with several other endpoints (for instance, Attach file or…
I have a report that beautifully aggregates data from 70+ sheets. I need one column from that report to populate a helper sheet that I have: Source Sheets > Report > Helper Sheet As the report grows with data, I want the helper sheet to grow with it without manual intervention. Ergo, the API question. Here's what I know…
We're looking to create a Gantt chart by inserting the data and creating the chart via the API (actually via the Java SDK, but either will do). Inserting the data is fine, but cannot seem to get the setDependenciesEnabled (which believe need for the Gantt ) or setGanttEnabled() to work… We think part of this is the order…
