Is it possible to have a red/yellow/green circle symbol appear in a column if the cells of another column meet a certain range criteria? For example, I want a green symbol to appear when a cell has a …
Hi all. I am trying to do a rather complex operation on Smartsheet, generally performed in programming. I have two different sheets: one for Departments and another one for teams. Both sheets can be l…
I am looking to rename certain values that I have in one of my columns. The original column contains values that are accepted in our database (intended for database input), and the new column would be…
Hi, I have one column written in a currency format. Lets call this column A. Another column written in a regular number format B. When I try to create a column formula in Column C like: Column A/ Colu…
Good afternoon, I was wondering if it was possible to filter rows submitted by a form depending on a priority. For example I have 3 parent Rows that are High, Medium, and Low priority. If a new issue …
I have a "filter" table in which I can choose via dropdown "year" and "month" values. By updating the values there, I can update the values in other small table I plan to select individual values cons…
I am looking for a number which can categroise row hierarchies into numbers. I have a column called "Hierarchy" and in each row I want it to generate a number depending on what hierarchy the row falls…
Hi, I'm trying to calculate if we're meeting the schedule start date. The issue I have is if the Schedule Start Date is greater than today's date then it still thinks its completed on time. I think I'…
I have two sheets with identical columns - Market Name and Organization Name. I'm using dropdowns in these columns since I have external folks reporting into a form and I want the names to match acros…
I know you can do this at the cell level, but is it possible to link an entire column? I'm trying to save the time of linking over 6000 cells and want the ability to grow as I know the numbers will be…