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 need to setup automations based on a contract date that will notify me on a monthly/quarterly/annual basis so I can process paperwork at the appropriate time. Ideally, I'd like to set it up to send an email 90 days before that date. I have columns for the initial contract date and the frequency (one for the word…
Hi everyone, Is there a way to set a dashboard as the default homepage for all users upon login? Ideally, we’d like users to land directly on a particular dashboard instead of the usual default page. Is this possible through configuration, or is there a plugin or workaround that can help us achieve this? Thanks in advance!
I created a "move row to another sheet" automation where the trigger is when rows are changed and ACTIVE / INACTIVE status changes to INACTIVE. When I changed the status in one row, the automation was triggered and now all of my rows are gone, and they are not on the destination sheet either. Where is my data? There is no…
