-
Report viewable to others
Is there a way to make a report I have automatically available for others to view it? Daily I click refresh on a report so the executives can have the most up to date info. My boss clicked on the report and it was empty. The report was shared with her as an editor. Can others not view the report anytime they want?
-
Help with countifs formula
I am a bit new to complex formulas so hoping someone can help. I am trying to add a column on one sheet, that falls into two basic categories on the same sheet. The formula I am using is as follows =COUNTIFS({MM Non Prod Issue Tracking System}, [Distinct System]@row, {MM Non Prod Issue Tracking Days Old INT}, <=30, =[down…
-
Data Bars (%Progress) in Cells
In MS Excel, you can use the Data Bars feature under the Conditional Formatting menu to create data bars within the cells. These can represent % Progress (see attached example). Is there a feature in Smartsheet that allows this? The Progress Bar under the Visual symbols is in 25% increments depending on selection of…
-
Control Center - Global Update: Adding Metadata to Existing Project from Intake Sheet
I am trying to perform a Global Update to all of our existing projects to include additional data for us to report against that is currently captured on our Intake Sheet. I have been successful in adding this additional reporting data to newly provisioned projects but am unable to now incorporate it into each existing…
-
Project Approval Received / Master Project Sheet Populated
I'm trying to setup an intake process where a new project is submitted through a form and appears within a project intake sheet for review/approval/denial. If approved, I'd like certain, if not all, column values for new projects to be copied over to a master sheet, which includes additional columns for project charter and…
-
Material Tracking
Please help haha It is difficult to put into words exactly what I am trying to accomplish, but I'll do my best. Please ask questions if I'm not being clear enough. Example: I have a material column for material that is being delivered to a job site (Sheet name is Delivery Tracker). Each cell in the column is an individual…
-
Hiding rows
I would like to be able to hide rows can only find option of hiding columns. It would be especially helpful if hiding rows option could be added to conditional formatting.
-
Formula Help
Can anyone help with this formula? It works in excel but I am getting Unparseable error in smartsheets. =IFERROR(IF([QTY]@row,<>0,[QTY]@row*[Production Rate]@row),IF([Linear Feet]@row<>0,[Linear Feet]@row/[Production Rate]@row,[Sqft]@row/[Production Rate]@row)),0) Thanks for any help
-
V lookup in sheet summary
Is there a limit to the number of V lookup reference sheets I can use on a sheet's summary tab? It seems like when I change a field to reference 'Sheet A,' and save, the other fields also change to 'Sheet A' even though I indicated 'Sheet B' for that field.
-
Automatically alert when project goes beyond an install date
Hi, We have multiple (50+) projects and once the project commences an install date with the customer is fixed. I have set this up in smartsheet, to have the install with no prior dependancies. What I wont to do is set up an alert when the project build is after the agreed install date. Any ideas on how I can do this?…