-
No restrict to dropdown values on form
On the sheet, if I dont check on "Restrict to dropdown values only", then I can type a new value into the dropdown column. But on the form, I cannot type a new value, even I choose not to check "Restrict to dropdown values only" on the column properties. Is there any way that I can create a dropdown field on form and still…
-
How to automate putting rows (based on conditions) of one sheet to a second sheet?
Hi, My sheet 1 has a structure with column 1, 2, and 3. My sheet 2 has a structure with the same columns as sheet 1 - column 1, 2, and 3 - plus new columns column 4 and 5. Based on values in column 2 in sheet 1, I would like to export the row in sheet 1 that satisfies a condition, to sheet 2. Once sheet 2 is updated, I…
-
New Graph functionality
Hi, We have been pining after graph functionality for a while in smartsheet and thought the latest release may have addressed this. Could anyone suggest a way to address the following (please see attached picture) We would like to add a target line to a bar graph to visually see where employees are over allocated.…
-
Dashboard and Sheet Not Updating Cell Referencing
I have a sheet with multiple countif formula referencing data from multiple sheets. From this single sheet, I have created a vital live data dashboard for multiple users to view and make decisions based on it. However, when I log back into my for some reason I see the totals in the dashboard reflect old data, and when I go…
-
Multiple sheets consolidate in a hierarchical single sheet
We have sales team members having their own sheets to capture their client info and industry-specific potential billings. Please see attachments exec1 and exec2 Is there a way for the Sales Manager to view all of this in a single sheet that is grouped by industries? The fixed objects are Industries. The variables are the…
-
VLOOKUP Calculation Lag
Hi, I am having problem with a VLOOKUP process. Our current process flow is as follows Import data into a "DataDump" sheet through API, at this point each row of data is assigned a number, matching that of the row number (we do this so we can use an index match formula to pull data through to the secondary sheet we call…
-
Children not displayed
I have a list of that will not open up today. There are 671 children and the "+" and "-" changes but the rows are not displayed. Help please! Rose
-
Format key and Primary Column
Hi all! I have two questions: 1. I have several conditional formatting rules that change colors or font based on contents. Can anyone recommend the best place to put the "format key" to indicate what each color and font means? I currently have it in an attachment, but that's not so easy to reference. 2. Does the Primary…
-
Admin Report - Sheet Tracker
Is there a report or query that can be done from the Admin account that shows all the sheets created in our cloud instance. I see that there is a total like 363 out of 500 sheets used, but it doesn't show date, who, sheet name and current status of that sheet (archived, deleted, new, etc). Is this possible?
-
Conditional Formatting Help
See Screenshot Example Please Goal: to compare cells in 2 rows across columns. All numbers in both these rows are based off formulas. I want the cell in row "needed machine hrs" (column 1) to turn RED, IF the number is greater than the number in the cell directly below it, in row "Current Machine/Labor Hrs" (column 1). Is…