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.
Hi At https://developers.smartsheet.com/api/smartsheet/openapi/rows/rows-addtosheet the documentation says that a 'permaLink' attribute can be returned, "if the include query string parameter contains rowPermalink". So I've set my POST request to: /sheets/#{sheet_id}/rows?include=rowPermalink and sadly had no luck. I have…
Is new python sdk available for new end points. Is Sunset date moved to Jun-2026
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…
