-
Automatic Capabilities
Hello, I am looking for a little direction. I am new to smart sheet and went through basic capability trainings etc. However, I am looking for assistance in having a smartsheet automatically move information down and date it. Quick reference to help better understand my question. I work for a commercial real estate…
-
Changing Distribution List on Recurring Emails
I have a sheet I created that auto sends every Monday at 4pm to a specific group - many of whom dont have access to the actual sheet. I want to add someone new to that group - do I have to redo the whole thing? I dont seem to be able to edit the distribution list. Thanks!
-
One column isn't filtering
I have a smartsheet with one column not filtering. It does consist of numbers (i.e. 1.750, 21.875, etc) so I tried entering the entire number, but still no luck.
-
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…