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 Smartsheet Team, Thank you for the notification regarding the upcoming API changes. We primarily use the Smartsheet API through third-party integration platforms (Zapier and Domo) rather than custom-built solutions. I would like to clarify the following points: Will Zapier and Domo automatically handle the API…
Hi Everyone, I have a Console Application that was developed using .NET Core 3.1 and Smartsheet SDK version 2.126.0. The application currently uses the following endpoints, which are scheduled to be deprecated in early 2026: GET /workspaces/{workspaceId}/folders GET /workspaces GET /workspaces/{workspaceId} GET…
Hi, Zapier Integrations team here. We are experiencing users reporting being unable to set up a webhook subscription to Smartsheet when a POST request is made to https://api.smartsheet.com/2.0/webhooks Response received { "errorCode": 1008, "message": "Unable to parse request. The following error occurred: Field 'name'…
