-
Activity Tracker
Hi, I have lots of sheets with different stakeholders who update these sheets, I want to check which row items have not been updated after their due date or Actual End date. How can I schedule report like that?
-
Building a Dashboard from a Report
Is this possible? I went to try and create a metrics sheet from the report but it doesn't show up. Building the report was supposed to group all of my similar items together, why can i not then build a metric sheet to create my Dash based upon that report?
-
Send Request for Approval Again
Hi: I have a column set up that an instructional designer changes as the status of a project changes, and I have another column that indicates the status of approval. When the ID changes the status of the development to "In Review", a trigger sends the Program Chair a request for approval. If approved, the ID can change…
-
SUM or COUNTIF across sheets
I have a Smartsheet for each fiscal year, and will continue to add new sheets for each FY. On a separate sheet, I want to find the sum of values that appears in all of the FY sheets. For example, if I want to sum the total amount an employee makes on my Summary Sheet, referencing data on multiple FY sheets, I know I can…
-
How do Link a Column w/ drop down items between separate forms/sheets?
I'm new to SS. This is my first project. I have an audit process I am building for a customer. There are 5 separate forms needed for the audit process. I originally had all 5 forms feeding the same sheet but with over 100+ columns for each audit, I went crazy scrolling left to right looking for the information I needed and…
-
Can I set a dynamic default value in a form?
I use a form to help my team record a log of completed work but I have an issue with recording the date. There's a date field on the sheet and I've added it to the form but I want it to default to today's date (whatever that may be when someone uses the form) and I can't find a way to do so. I can set a default value in…
-
Notification Options when Saving as New
Is there a way to have all the Notification & Sharing Options checkboxes when saving as new? Is there a setting that can be 'turned on' to do this?
-
Formula in Resource % Allocation column
I have added a column to put in the number of hours I would expect the task to take each day. I prefer this to having to work in percentages of a day and think this will be easier to request of my team. To allow this I need to put a formula in Resource % Allocation column to divide the number of hours by the number of…
-
Using COUNTIF to determine quantity of rows with number not ending is 000
Hello, I'm trying to setup a "Line Quantity" of children where the primary column contains a 5 digit number. These numbers indicate line items of a purchase order and have a hierarchy themselves. The numbers that are considered the parent end in 000 with all the items that are children end in various numbers in increments…
-
recruiting conversion metrics
I'm looking to connect with anyone using smartsheet for tracking recruiting conversion metrics! My team currently uses sheets for tracking all candidate submittals and feedback between recruiters/HMs. Has anyone created a report or sheet to track the funnel conversion metrics from submission to hire?