-
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…
-
Request for generic color coding symbols
Please consider the addition of a "Generic" category of color symbols that we may attach to text/number columns for personalized categorization driven by formulas, etc. For colors, I would recommend a standard ROYGBIV plus black and gray. For symbol types, I would provide the above color scheme for circles, squares, stars…
-
need cleanup of logical formula
Could someone help clean up the following formula: =IF(AND(TODAY() >= Finish2, [% Complete]2 < 100), "Red", IF(AND(TODAY() < Finish2, [% Complete]2 < 100), "Yellow", "Green"))
-
G-Suite reply in comments
I successfully have my emails in Gmail landing in the comments in a particular or new line in a sheet, works great and very helpful. I see in the added email in comments a "add reply" blank. Does this reply just stay with the comment or does it go back out to an email Maybe this is a wish list type of thing, but if a…
-
Forms
Is there a way within a form to redirect a user to a new form, based on selection?