Is it possible to apply Conditional Formatting to a cell based on the number of characters in the cell? I can think of how to do it using a helper column, but I'm curious if there's a way without adding an additional column.
Hey @Ben B.
Conditional Formatting does not currently have way of evaluating a cell to see how many characters are in it; I would also suggest using a helper column with a LEN formula to count the characters, then base the formatting off of that column instead.
@Genevieve P. Thanks! I ended up using helper columns and the LEN function.
Hi all, I've set up a Accident and near-miss report through a form, I want the entries to be view-able by staff (not all columns, as they might). So I have made a report -filtering on what I do and do not wnat to display- which I have in turn -among other metrics etc- put into a safety-portal dashboard. The issue I am…
I am a business user but Data Shuttle is not activated. How to activate it?
Hello I am trying to calculate a sheet summary field to show how many times a value appears in the Location column. I am using the Count if function but it is only returning a value when the "location" is presented on it's own. For eg: my formula is =COUNTIF([*Location]:[*Location], "VIC"). This formula responds with a…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.