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.
Hello- my co-worker is getting the Opps something went wrong error. Also know as a 500 internal server error when accessing workapps. Can you please help?
You can now create, read, update, and delete reports programmatically via the Smartsheet API. Reports are no longer UI-only — they're a first-class API resource, just like sheets. What's new The Reports API now supports the full object lifecycle: Create reports from API calls — no more manual setup in the UI Read report…
Hey dev friends, We just kicked off a new hands-on learning series for the Smartsheet API Developer Ecosystem: Mastering Smartsheet API. From your first API call to production integrations and the new MCP Server for AI agents — this series covers the full path. Part 1, "Zero to API: Your First Successful Smartsheet…
