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!

Mike Wilday

1. Create your RYG column
2. 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