The ability to apply conditional formatting rules from within a report would be huge. Having to modify the Source sheet for a specific report doesn't seem to be very efficient.
Good morning, I am facing an issue on my smartsheet, i have a column (dropdown list type) that allowed multiple values per cells and i am trying to manage these different values in order to concatenate them the way i want in another cell. Does anybody knows the way to pick a single value from all of them or even the way…
There currently isn't a way to automatically collapse lanes based on criteria (such as "no cards") or to use one click to collapse all. Currently I have to click each column to collapse individually, to show/hide what I want.
This discussion has been merged.
Hello all, I am trying to format a column based off of another column. I have a column for amount desired and another column for amount received. I just want to make them turn green when they are equivalent. I have read about adding a helper column to make this happen but get stumped at incorporating it. Any advice/help…
Hi! We are a smaller company that uses smart sheets with internal sheet as source of truth and then an external sheet that is meant for our external collabs to fill in. We are trying to error proof as much as possible because our techs run testing scenarios that require external contractors to solve. So we create an issues…
Howdy Smartsheet Community :) During a recent exercise to make Conditional Formatting programmatic, I indexed the color names and hex codes of the 8 x 5 Smartsheet color matrix. Wanted to share the results with everyone here, in case you have a need to extend these colors through non-Smartsheet collateral: Some details on…
We are wondering if anyone knows how to build a public facing sheet that has a search box where customers could type in a word or two and then have it return any hits. The data that would be searched could be linked to another sheet and that file would not need to be viewable on the public one. Is this possible?
I have a column named "Creation Date" (Date Type) and another one named "Response Due Date" (Date Type). The "Creation Date" is automatically recorded whenever a new row is added. How do i automatically set a date 3 weeks later in "Response Due Date" column. KEEP IN MIND PLEASE, that i already have 100 rows with manually…
