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.
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…
Within the Add Row workflow element, Bridge throws this error when I simply trying to send a contact list value from one sheet to another sheet in Smartsheet Bridge. I understand that the "to" sheet is requiring the value to be an email but I can't find the object value in the Run Log. @Genevieve P. hoping you can help.…
I tested three methods: get sheet (Python SDK) raw HTTP request get row (Python SDK) Method Total Has att Empty get_sheet 11153 4379 6774 raw HTTP 11153 4379 6774 get_row (last 10) 10 10 0 get_sheet (last 10) 10 0 10 raw HTTP (last 10) 10 0 10 I can confirm that every row in this sheet has an attachment.
