-
Centering Title of Widget
Hello, Does any know how I can center a title located in a sights widget?
-
using SumIF with Children, a multiplier and 2nd Sumif
I am trying to multiply a number based on two levels of hierarchy. Currently it looks like this: =SUMIF(CHILDREN([Rep Level]1), "1", CHILDREN([Sales Commission]1) * 0.07, SUMIF(CHILDREN([Rep Level]1), "2", CHILDREN([Sales Commission]1) * 0.03)) My error is an incorrect argument set. Any sugestions would be great.
-
Adding task line in one sheet and displaying in/moving to another
I have individual sheets created for 4 people (one being mine) where we have lines for all our tasks. I use a Report to consolidate all 4 sheets. However, when I have a new task I want to assign, I prefer not to have to access each of their sheets to add a line. I'd like to add the task line on my sheet and assign the Task…
-
Best "infrastructure" columns for portfolio reporting
I am wondering if someone has some advice on the best infrastructure columns to add to project sheets to enable formatting, portfolio rollups, metrics, etc. I current have automated checkbox hidden columns for parent, child, ancestors, milestones, status (based on due date). What other hidden columns do people include in…
-
percentage complete
I have a formula on a parent row that counts all children, and gives me a percentage complete....however I need it only to count some children, I want to refer to another column that I am using the star symbol to activate certain reports, so I want it only to count the the rows that have no star....below is my current…
-
Visibility across sheets when using cross sheet references?
I love the new cross sheet referencing feature - this has been a big hole in Smarthseet's feature set. But I have a question - I see that when a cell is clicked on (on a sheet containing the reference range) that is used in a cross sheet reference, a link to that sheet appears. When that link is clicked on, a preview of…
-
Forms
Looking for some help in a Form that I'm creating. I am the Safety Director for a painting contractor and I'm trying to create a form that my crew forman will be filling out every morning. Why can't I have more than 1 field named the same? I'd like a check-box or drop-down field, for every employee, that specifies if they…
-
Items move to the bottom when marked complete
I'm helping my manager set up her "To Do" list and the way that she has been working is that she moves completed items to the bottom of the list, so that what she needs to do is always on top. Is there a way to set up Smart Sheets so that it automatically moves completed items to the end of the list? We know it can be done…
-
Copying Rows
I'd like to be able to add 1 row to multiple sheets at the same time. All of the sheets are from the same template, so all columns are identical. The best thing I have found so far is to create the row, then copy it to 1 sheet at a time, but it's still very time consuming. Any ideas?
-
Customer research sign-up: Assigning tasks to multiple people
The Smartsheet Product team is setting up interviews with customers who would like to assign tasks to multiple people in Smartsheet. Your input will help to shape the future of the product. Please sign up here if you would be interested to participate in these interviews. We look forward to hearing from you. - Daniel…