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!!!
You're welcome! Glad I could be of assistance.
Completely understand, thank you so much for your help!
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.
I script in python. I need to explain some things about how we use Smartsheet. We have a master sheet that has all of our current orders on it. We have around 200 projects, and each project has its own project sheet. When an order is placed via update request, a daily script picks up the info and creates the order on the…
I'm trying to get APIs to connect some of our project management documentation with our existing customer-facing documentation housed in Application Lifecycle Management. We have been able to get the calls working and pulling the desired data into Smartsheet, but as soon as we add additional columns (contacts, text and…
Hello - I am trying to update my APIs due to the deprecation announced. I am having trouble with the new share API for sharing a workspace. Below is what I have in my HTTP request, and the error I am receiving. I have tried a few things, but I can't get past this error. Share asset { "assetType": "workspace", "assetId":…
