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'm trying to create a graph chart that captures monthly count of records by divisions (Northeast, West and Central) that should be stacked with a legend displaying each by different color like a presented in Excel. When I attempt to duplicate the process in Smartsheet I receive the following results. In Excel, I created…
Good afternoon, I am trying to utilize Linked Dropdown Columns for a manual process we have. We have many sheets that use a "Client Name" column with a dropdown list. Whenever a new client comes on or exits, we have to manually update every sheet that has a Client Name column and update the dropdown list. We do not have…
This should be straightforward information but I can't find it anywhere. How do the Automation triggers work for attachments? I assumed: An attachment is Added = New attachment An attachment is Changed = New version of existing attachment. But I just had an 'Added' attachment notification trigger when I uploaded a new…
