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, has anyone received this or similar error yesterday? upstream connect error or disconnect/reset before headers. reset reason: connection termination I got it once but haven't since, I suppose this is something coming from the smartsheet's api's end?
Hi dev friends, Heads up — the includeAll query parameter is being sunset on June 3rd for list operations on workspaces, folders, shares, and more. This affects both direct API calls and all Smartsheet SDKs (Python, Java, C#, Node.js, Ruby). Check the Changelog for the full list of affected endpoints and migration guides —…
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?
