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.
When you work with data in a spreadsheet or an AI client, what usually happens before it ends up in Smartsheet? Pick the closest one, and tell us how it really goes if it’s messier than the choices. It usually is. I copy and paste it over by hand I export a file and import it I clean it up in a spreadsheet first, then move…
At ENGAGE 2026, five customers showed what they’ve actually built with AI on top of Smartsheet. No roadmap slides, just working setups. Here’s the short version: Lilly Kinsale: One live changeover view, built with Claude. It saves roughly 30-35 minutes per core team member every day. Swampfox: AI proposes RAID log updates,…
I’m looking to use Linked Dropdown Columns within a CC blueprint template My setup is that each provisioned project gets its own workspace containing: Project Plan Team Roster I want a dropdown column in the Project Plan to be linked to specific column in that same project's Team Roster. For example: Project A Project Plan…
