-
How to count different status from one column
Dear all! In our projects we use smartsheet as data base for elements of decor. At the moment we have four different statuses on each elements. In this case would like automatically count all red, blue, yellow and green statuses and see how many elements we have on different production stage. I know how to coun all…
-
Average % complete if task is assigned to "xxx"
What I am trying to do is figure out an assigned user's bandwidth. I am doing this by having them assign a % Complete to a task and then averaging the children =AVG(CHILDREN()). What I want to be able to do is average the children but only for specific assigned users. So average the children (% Complete) for tasks assigned…
-
Improving the context of answers to community questions
Hi all, can I suggest that as there are lots of new users to the community since it was launched only a few months ago, that existing and new members add a little detail about themselves? That extra info should make it easier to see the context in which a question is being framed, so the answer is more appropriate?…
-
Can multiple web-forms feed the same row upon submission?
Good Morning, I would like to have two webforms: one for an external user and the other for an internal user to each fill out and submit separately but have all the information from each webform compile and fill into the same row on the master sheet. Is there any way to link the two web-forms so they can feed the same row…
-
Smartsheet Charts with parameter
Hello Community, Anyone familiair wiith the charts via https://smartsheetlabs.com/ ? Is there a way to feed a chart with data without having to make a new sheet or report for every chart ? Example: - within 1 sheet I have a project which has several taks, each with planned hours and actual hours. - in a separate website, I…
-
Security: why is a stranger requesting access to my smartsheets?
Received an email today from smartsheet saying some stranger is requesting access to one of my smartsheets. How is this happening?
-
Restaurant Project Opening
Wondering if anyone has developed a smartsheet to manage a New restaurant opening process? Looking to program in an opening date and then have all tasks tied to this opening based on number of days out from opening. Thanks!
-
Build report within a specific sheet?
Hi I've been setting up a standard highlight report (sheet) and have built links from my risk, issues and exception logs. Everything is working great so far but I want to automate some additional logic. I now want to bring in a list of 'deliverables' that have been completed during a specific period and then identify any…
-
Changing the Fiscal Week from January to July (or any other month) does not affect the Timeline week
I am trying to view my Sheet in Gantt view, tracking top row by month and second row by week. This works fine, except my company's fiscal weeks are offset. I changed the settings modifying start of fiscal week to July, but the view on the Gantt didn't change. Same result using any of the other available months as start of…
-
Combining Text and Formula Into Same Cell
Hello all - I am trying to imbed a text string into a formula (using the NETDAYS() function). The end result would be something similar to: "Number of days between Kick off Meeting and Final submittal is [RESULT]". I am able to use the formula in a standalone cell with no text. In an adjacent cell, I am able to create a…
