Sign in to join the conversation:
Id like to highlight a cell in particular column when it matches another column, cell is same row. I dont seem to have an option in conditional Formatting in 'Set Condition' to say 'if Column A = Column B'?
Hi Andi,
You need to use a so-called helper column for that. You could use a formula in a checkbox column that checks if two cells are the same.
Would that work?
Have a fantastic week!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
Good afternoon! My company works closely with another ambulance service, Company B. Both companies have a Smartsheet Enterprise plan. I have created a workspace that I need members of Company B to edit. Do I need to make them members on my account if they are already members on their account? Or do I just need to add their…
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…
I have shared sheets and dashboards with people outside of my organization, and one has a paid license. Would I be able to grant admin access to this licensed user to their sheet? Or would the ownership of the space by one organization limit the admin accessibility of someone from outside?
