-
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.
-
Smartsheet Color Matrix Names and Hex Codes + Programmatic Conditional Formatting
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…
-
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?
-
How to generate an ID number, incrementing by 1 the last ID number created in previous row?
I have a sheet with already multiple rows created. I have a column with ID numbers for each row. I want to set up an automatic way to generate an ID number for all future rows added. For exemple, the last row created has an ID number of 2300. How to automatically generate an ID number of 2301 for a new row added?
-
Conditional Formatting on Forms
I'm drawing a blank on the best way to do this. I am building a form where there is an option to select criteria from a drop-down. When someone selects a drop-down option I want it to then link to it's accompany account number. Basically, that way when they select their account name and submit the form it is submitted with…
