Welcome!

Base rule off of 2 columns

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!

Sales

Real Estate

Create your RYG column
Add the following formula:

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

This should do the trick.

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

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

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

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

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

perfect!! thank you so much for your help

User Types for Update Requests/Forms
Hi there! Our Account Manager today informed us that users would need to be paid members to receive and complete Update Requests going forward. I can't imagine that Form users would need to be members, but I don't know how that differs from Update Requests, since neither requires access to the underlying sheet. Is it…
Generating documents from row data
This discussion was created from comments split from: Generate documents from row data.
Getting error - need help!
Error occurs when opening Vault Apps in Smartsheet WorkApps. The app fails to load and displays an error message despite logging out and back in. Issue has been ongoing since last Monday