-
I Need a Construction Daily Report Template
I am a construction project manager and I am new to Smartsheet and I'm trying to create a Daily Report template. I can search the web for Smartsheet Daily Reports and I find several "templates", which all say "Smartsheet" on them, but they are microsoft excel files. When I try to import them into Smartsheet, they never…
-
Return the NETWORKDAYS of 1 month of a 2-month duration
The goal is to count the number of days that an Employee is not assigned work within a given month (MONTH A, MONTH B, etc). For example, a given month has 23 working days; I could use NETWORKDAYS of the duration to count the assigned days of that Task; say 19. To reach my goal, I would simply subract the NETWORKDAYS from…
-
Formula Needed for Parent to Inherit Child Value
I don't think this is possible, but I need a formula where a parent row Status value reads "No Active Projects" until it has a child row below it with an "In Progress" status at which point the cell should just be blank. See image below. I use the "No Active Projects" marker to determine whether or not that department…
-
Stacked Column Charts
Hi all - I'm in the process of creating my first dashboard and struggling a bit. I'm attempting to create a stacked column chart to show a count of items by both Region and District. For example - Regions 1 through 10 all have 5 Districts within them, and I want to report on how many sales have been closed in each District…
-
Make the rich text editor edit report cells on the dashboard
Greetings everyone, I was wondering if using the rich text widget to edit a cell in your report on the dashboard live is possible. The logic behind it is: The rich text editor is linked to the cell from a report and updates data simultaneously. Thus, I wouldn't need to go back and forth to the report and then to the…
-
How to use Trend Arrows to show change in RYG
Is there a formula that would highlight the trend of a change in RYG balls ? For example, if someone changes the status of a project from Green to Red, it would show a down arrow. If someone changes the arrow from Red to Yellow, it would show a Upward arrow. Thanks for your help!
-
Date miss matching
Hi all, Ok so I reside and work for a company based in Bangladesh and we use this format for date ( Date / Month / Year ) so today will be 30/3/2019 I have two base sheet that feeds directly to a master sheet via direct cell linking which is used by the management to keep track of the latest updated. Now the base sheet the…
-
Summarizing a Customer Satisfaction Survey that is ongoing with monthly reports
I have created a Customer Satisfaction Survey with 12 questions that use a 5 point Likert scale. (Strongly Agree / Agree / Neutral / Disagree / Strongly Disagree). I have tested the web page and it all populates the SmartSheet fine. Additionally, the first 5 questions are about the sales person, the second 5 are about the…
-
Unique numbers in a column
I have a sheet that we add rows to everyday. One peice of data that is added with every new row is a case number (unique identifier to show us who we are working on). How can I get a total of unique case numbers? I simply want a count of all case numbers no duplicates. So if case 12345 is on my sheet 5 times I only wanted…
-
Count number of resources per project
Hi, I'm trying to count number of resources assigned to a project but I'm not sure how to go about it, when there is a duplicate. Meaning, if John Doe is assigned to 5 tasks, Jane Doe is assigned to 3 tasks, and Billy Bob is assigned to 1 task, is there a way to count the number of resources assigned to the project, which…