Please create an OR option for conditional formatting. I have a list of 50 numbers, and I need to highlight if any of them exist in a specific cell. Without an OR option, I have to make 50 rules to accomplish this. Frustrating!
Sign in to see the current vote count, add your own vote, or leave a comment.
Hi,
I hope you're well and safe!
Here's a possible workaround or workarounds
Would that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
I very much agree that this would be very helpful. Although the helper column solution may be a workaround, it is an additional complexity. If 'AND' conditions are workable, I believe so should 'OR' conditions.
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
Description: When users upload multiple photos in one action via the Smartsheet iOS mobile app, all files are assigned the same generic name and timestamp. This makes it difficult to identify individual photos and creates confusion in workflows that rely on accurate, unique file naming. Why This Matters: Industry Standard:…
Our consistent experience is that Smartsheet objects can take anywhere from 5-20 seconds to load. This feels extremely slow when you're actively facilitating a call and working between sheets, waiting for it to load. Other solutions in the industry have extremely fast, sub-5-second load times. I would request the product…