nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Welcome!

Base rule off of 2 columns

Julias

I'm looking for a way to create a rule that would be:

If Column "Status" says Funded, and Column "Fee" is blank, make the row Yellow

Is there a way to do this? I can't seem to figure out how to get 2 columns on there to create the rule

Thanks!

Find more posts tagged with

Sales

Real Estate

Conditional Formatting

Comments

Mike Wilday

Create your RYG column
Add the following formula:

=IF(AND(Status@row = "funded", ISBLANK(Fee@row)), "Yellow", "")

This should do the trick.

Julias

I get the error #unparseable so I'm putting something in wrong...

do I have to change anything in your formula or copy and paste? sorry I'm not usually this useless with formulas...

Mike Wilday

Can you share a screenshot of your column headers? That is probably where the issues lie.

Julias

here we go! so its the "status" and "finders fee" columns

Mike Wilday

Here you go. Smartsheet uses the column names to determine which column to check.

=IF(AND(Status@row = "funded", ISBLANK([Finders Fee]@row)), "Yellow", "")

Julias

perfect!! thank you so much for your help

Sign in to join the conversation!

Quick Links

Trending discussions

Created Date Time Stamp
Has anyone figured out a way to use a column as a created date but not have the time stamp? It causes problems for my manager trying to use that date to pull into PBI. I know how to convert in a helper column to a year-month and a year, but those have to be text/number columns, not date columns and he can't use those…
How to auto populate cells
I am looking for a way to automate a cell so that when column A displays 9 'Days Open' (or between the values 0-14) the 'Req Age' will auto populate (or trigger) the ranges provided. Image below: I want the highlighted section to auto populate based on the value in 'Days Open'
Why Can't I no Longer Able to add Folders, Sheets, or Reports in my "Sheets" folder
Good morning, I haven't needed to do this is quit a while but I went to clean up the "Sheets" folder in my account and can no longer create a folder, sheet, or report in any area of that folder. The "Create" button at the top right takes me the templates page. This is what I am seeing vs what I can do within a workspace.…