Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
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
I have build a email validation in my sheet where entered emails from a form are entered in a contact field. another field verify the address and validades using the following formula: =IF(FIND("@xxxxxxx.com", [Student eMail]@row) = 0, 0, 1) if the checkbox is triggered (=0), then the registration is valid, and the the…
I have a sheet that has a good number of automations that populate a field based on a value changing in a cell. These same automations have been working just fine since March up until today. All of a sudden they are being triggered when there is no change to the cells in question. If I click into the cell history, it…
Hi, I'm in the midst of a Smartsheet trial and would like to understand how to set up a project schedule that uses a firm delivery deadline. I understand I could use Start-to-Finish relationships, but this disallows use of many to one predecessor relationships (multiple tasks that are gated by a single work item). I would…
