-
Automatically update form link when creating new folders
Hello All! I have a folder template that has a sheet with task tracking. I have forms for entering certain tasks, Internal, External, and SCRUM tasks. Currently, I have a link to the form on a dashboard, however, the link is static and does not change when I copy the folder template and make a new project. Is there a way…
-
Predecessor Issue
Is anyone else having issues with the predecessors in SmartSheet? Right now, I have several sheets that have predecessors that have a duration of 1d and are following the row above without a 'type' (finish to start, start to start, etc.). As you can see from the screenshot, it has row 1 ending on 1/21 and row 2 start on…
-
Variance Netdays
Hello everyone, I read some of the threads about this issue, but cannot find the right answer. Members of my team are consultants and work primarily on weekends so I am using the NETDAY function to calculate the variance. If I use the formula as is, meeting the deadline will give a "1" instead of 0. To avoid this I added a…
-
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.
