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!
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
This discussion was created from comments split from: Licenses and True-up confusion.
Our users are noting that a specific column is not submitting the data they selected correctly. It is a dropdown column where you can only single select from the list. When checking the cell history, it is showing one entry for the incorrect item. While we aren't ruling out continuous user error, we have seen enough…
I created a new project in my PMO, when I tried to pick a contact there were very few listed 7 versus the 165 people in my org. I checked My Contacts and all of the contacts were listed. Do I need to link that somehow to my sheet? How would I do that? Second question, what is the best strategy to keep My Contacts updated…
