-
How to have separate data table for a new version of the form?
Hi All, I created a copy of the form I used so far, to ask a bit different questions and to collect the data in a bit different way. After the pilot stage I want to decide which version 1st or 2nd of the form will be used as the final version. But I see that the data punched into this 2nd version of the form are collected…
-
Automation - one workflow moves row before 2nd workflow can trigger
I'm new to smartsheet (having a blast!), and could use help adjusting my workflow automation to accommodate timing of certain actions near the completion of a task (row). Simplified scenario: Each row on a sheet represents activity that needs to occur to "new product samples" (one product per row); and when ALL activity…
-
Is there a way to reference the value in a cell as a numerical value that functions in a formula
Hi Community, I have a 13 week rolling chart. To gather, I have groups like this one below for each of the thirteen weeks. this one shows 10. Is there a way to change the value for the weeks ago portion (in red boxes below) to be a value in another cell? In other words, I could reference the 10 in the red box on the far…
-
Custom Print after Form is filled
It would be great if there was an option to print after a form has been filled. Also, if you can select which fields/columns to print from and customize the format. I am trying to create a ticketing system on a stand alone computer that would have a form perpetually on the screen for people to fill and print from. The…
-
Creating a team task management workspace.
I'm not sure if I'm limited by Smartsheets currrent capability, or by my own understanding of how it works, but I'm hung up on creating a task management workspace. My individual needs are: Isolated sheet that my team members can manage on their own, with my own ability to edit and view the sheet. This is their individual…
-
Smartsheet Knowledge Hub WorkApp
Going on 3 years in an enablement capacity and a people manager, I can identify the different Learning styles of my End Users and help them elevate their knowledge consumption and elevation levels. I am looking forward to designing a Smartsheet WorkApp for a Knowledge Hub that is multi-layer and dynamic by Web User's Role…
-
Smartsheet Dashboard to WorkApp
Hello. Like all of you, we have our customers that love to tell us their desired UX. I start off with honesty. No tool is perfect, there are limitations and we will address the must haves and nice to haves respectively. The biggest concern is addressing what value can Smartsheet bring that makes their work lives easier to…
-
Policies and Procedures
Hello, I serve as the compliance officer for a nonprofit mental health outpatient clinic. We are new to Smartsheet. Our goal is to have a single source of truth for policies and procedures. I used the Risk Assessment template and found it easy to work with. Now working with the Policy Governance Inventory template. Diana
-
Need help excluding weekends in estimated completion date formula
Hello! I am currently working on a Smartsheet that estimates how long a project should take depending on a multitude of variables. So far all my formulas are working great, but I am using the following formula to determine an estimated project completion date: This formula is unfortunately accounting for weekends as well,…
-
traffic data in 6-hr intervals over a 12-week period
Hi All, I want to show data in 6-hour intervals over 12 weeks (Feb 2024 till April 2024). How do I create a dashboard for it? Columns include: Only if I can know the total number of tickets received for the past 12 weeks in 6 hour timely interval for the past 12 weeks Any help would be highly appreciated.