-
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…
-
Feature request - dynamic lists
Dynamic lists would be a very valuable feature in smartsheet. When we add a new employee to our system, we need to add them into about 10 different sheets, so that they can select their name from the relevant lists and fill out a timesheet, project reporting etc. If the new employee could be just added to a dynamic…
-
Update Frequency
Dear Smartsheet, Please stop the almost daily updates and concentrate on releasing functionality/fixes in a staged manner like every other company out there. I've even had days where there are 2 or 3 updates. It's best practice to provide cumulative updates and as a courtesy to your customers, it should be adopted by…
-
Shared Filters
Is there a way to save a filter and use across all smartsheets? I want to be able to create a filter and then share will all my co-workers.
-
Linking to other cells
Hey, So we have 2 sheets. New Projects sheet and Tasks sheet. The New Projects one have 2 column. ID and name of the project, whenever we get a new project we insert the name and ID manually. I want the Tasks sheet to have those column as well (ID and name) and I want it to be dynamic. Meaning we add on Projects sheet, it…
-
Forms, Formula and fixes - Oh My!
Hello, I have created a web based form in which the user fills in certain information. As part of our metrics we need to keep track of when an quote is finished and completed. I have a date column for the quote finish and a checkbox cell for complete status. Our reports use the checkbox cell as the primary filter.…
-
Formula / Multiple Sheet Reference Assistance
Hello! I have a summary sheet that references five sheets. I already had to modify my ranges for VLOOKUP on those sheets because I hit that 25,000 cell reference within moments. Three weeks later after changing all of my sheets, I'm ready to proceed to the next step in my project. I have one column that uses a VLOOKUP to…
-
Smartsheet collaboration with Microsoft Teams
Hi, I want to know the accessibility rights of the different types of users (licensed, non-licensed, collaborator...) Example: I want 2 users to be admins so they can add users and create sheets. And I need 20 users to be able to access the sheets, input, and edit information. Also, I need 100 users to be able to view the…
-
Countifs - with Hierarchy (Grandchild)
I am trying to write a formula to count the lowest level of "Completed" items. I have multiple Projects and different Status all on the same sheet. =COUNTIFS((CHILDREN[Variable Features/Tasks]:[Variable Features/Tasks]), Status:Status, "Complete", Project:Project, "Test") I'm not working in excel - I just wrote up the…
-
How to make formulas work on top of a sheet if new entries are coming on the bottom of the sheet via
Hi All I am really stuck with this as I need to amend my fomulas manually every time I have a new entry. Whenever there is a new entry ( via Web-form) I need to change the formula to include the new row instead of helping me with automation it has created extra work for me. Did any of you faced a similar problem? What…