Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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.
I tried using the product feedback form but it kept failing so I'm posting here instead. It's possible this is user error but I hope not for my ego's sake :). After the APIs were recently updated, my GET /users API call is only able to return a result of 2000 records in an array per page when I use pageSize as the…
Goal: Power Automate to update SmartSheet Row with "In Revision" Status when selecting "Reject" for my "Wait and Approve" workflow I have a Power Automate approval workflow that is triggered when a Smartsheet row is updated. The approval process works correctly, but I'm trying to handle the Rejected outcome. When an…
Receiving this error every time I try to save a change to a single sheet or access the Automation menu. All other sheets are working correctly. I've tried multiple browsers, clearing my cache, restarting the computer and checking for Smartsheet outages. While I'm actively working on developing the sheet further, there are…
