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 need to revise/expand a filter - the list of items in the filter NOT the filter name - in a dashboard I created. Is this done through the dashboard or through the main data sheet?
I have a sheet set to notify myself and another user when ANY CHANGE is made to the sheet. Neither of us received the notification. Any suggestions on why this is not working? It has been a while since this form was used, but it worked previously.
My reminder in smartsheet automation is set to trigger every day starting 12/05/2025 at 8am (gmt+1) and the condition is to send the reminder to the contact in the contact list if the reminder flag is set to 1 and the status is not one of DONE. Currently on the sheet, a task has the reminder flag set to 1 and the status is…
