IF Statement for a whole row

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!!!

Find more posts tagged with

API and Developers

Healthcare

IT & Operations

Comments

Mike Wilday

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.

Lisi

Completely understand, thank you so much for your help!

Mike Wilday

You're welcome! Glad I could be of assistance.

Sign in to join the conversation!

Quick Links

Trending discussions

Alternative API endpoint for listing workspace templates after Feb 2026 deprecation?
With the announcement of the deprecation of "/workspaces/{workspaceId}" and the deprecation of the template listing endpoint (https://developers.smartsheet.com/api/smartsheet/changelog#template-listing-endpoints) There does not seem to be a way to retrieve a list of templates for a given workspace. Our app relies on these…
Auto Create Child Rows from Dropdown; how to get array values to auto populate each child row
Hello :) I am building a project management system where we have: Asset (Parent Object) Components needing fixing/replacement (Child Objects). In my Bridge workflow I have managed to achieve child row creation based on the number of values in the dropdown cell (components). I need to add a feature that spreads each…
Sheet modifiedAt
Hello, I found that sheet modifiedAt field in "List Sheets" GET method sometimes is different than modifiedAt field from "Get Sheet". Is this normal ? When I change a value in a cell, Get Sheet method returns the last modifiedAt date but List Sheets remain with the old value.