Sign in to join the conversation:
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
I have a form that will be filled out internally. There's a cell labeled "Department" which contains 8 dropdown list values. There's a another cell called "Executives" which are the leaders of these departments. In the form, I'm attempting to do a logic where when you choose a specific "Department", then the cell…
I shared access to a user to a specific folder under workspace A (folder is 2025-09-Service Factory). However, I can see that he's shown to have access to all the other child folders under 02-ACTIVE Initiatives. Why is that when I only shared out one folder? Is there a way to only share access to users to ONLY specific…
what i can do if all my existing smartsheet gant files can't be open after change my plan to Pro? what could be the reason ?
