-
Manage multiple values in a cell from a dropdown list
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…
-
Collapse Lanes in Card View
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.
-
Merged: Custom Colors on Cell Formatting
This discussion has been merged.
-
Conditional Formatting based off of received versus desired
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…
-
Copying sheet rows to another- where it copies, work around so its not the bottom??
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…
-
Merged: Conditional Drop Down List Values
This discussion has been merged.
-
Is there a way to create a search box?
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?
-
How to automatically generate a Date that's three weeks later than a given Date in another column?
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…
-
Is it possible to have a column only be available to be selected based on the status of another?
I have a drop down column that captures the study status and I have another column that is a check box indicating the information has been reviewed. Is there anyway to have the option to select the "information reviewed" column only when the study status column reads "completed?
-
Conditional Formatting "if in past of X date"
I want a cell to change colour if the row/s were created in the past of a certain date. For instance any row that was created before 1st May 2024 will have a cell change colour. Anything after that date will not be affected. Is this possible?