-
Formula Suggestion: [Column Name]@ to Imply "[Column Name] in This Row"
I would like to offer an idea to the Community to see if this has any support. There are plenty of examples of complaints throughout the community of sheets with complex formulas dogging down the sheet during saves. This can be exacerbated greatly by trying to move rows around the sheet, and the thousands of cell row…
-
Task Details
Hi all - I have a project with several tasks that have discontiguous components. For example, in one case I have a monthly meeting that I want to note as a single task that starts no later than 1/1/17 and ends no sooner than 12/31/17, but will only consume 12 resource days. I know I could set up 12 tasks under an 'umbrella…
-
Parent/Children Conditions
I'm new to Smartsheet and am trying to set up a regular monthly task list. I have certain "parent" tasks, and under each are a few sub-tasks or "Children". I have a checkbox to show that each line is complete. Is there a formula in the Parent row to check the box if all boxes are checked in the Children rows?
-
Help Desk - Communicating with end user
I'm using the Help Desk template to manage my incoming tickets. However, I don't see a way to be able to communicate with the end users within the system. I would like to be able to email the end user and have the email chain as an attachment to the row in the Smartsheet. Is this possible? It also doesn't seem to notify…
-
Formatting for Project Lists - suggestion
I was hoping there was some formatting option so that when I set a status to complete (either green orb, full circle etc.) that there would be a way for that row to automatically be moved to the top of the sheet. That way the "in progress" and "completed" tasks/projects could be better organized. Just an idea. Thanks
-
Assigned To Notifications Not Working
I have several sheets with Assigned To notifications set up and they are not sending emails upon assign. I'm hoping I'm doing something wrong, but I've searched these boards and it looks like I have it set up as suggested. Here is a pic of my settings. Please help!
-
Filter - "at least one condition" - wrong results
Hi, I may be going mad, but I cannot get a filter with at least 1 of 2 conditions to work. Maybe my boolean is getting rusty... I have 2 columns with monetary values. I only want to show rows where at least one of these is bigger than zero. Nothing complicated. The settings are attached in the screenshot below. However I…
-
Count If - Status Symbols
I am trying to count the number of cells that have Status (Green) in my status column i am using a dropdown with Symbols Green, red, yellow. I am trying countif but don't know how to specify the 'symbol' green. Any ideas?
-
Printing A Sight - printing so small that you cannot read data
Looking for some advice on printing a fairly large Sight. I have had no issues with printing Sights that aren't much larger than what fits on your screen. Push print and that's about it. But - when I tried to print a Sight that was much larger (scrolls down several times in order to see all of the data), it would not scale…
-
Opening a link to a sheet (Smartsheet), while utilizing the Smartsheet App
I have employees that exclusively operate within the Smartsheet App (iPhone & iPad). The sheets that we are working with, contain hyperlinks to other sheets. Upon opening the link to another sheet, while in the app, it redirects the employee to the web version of Smartsheet...it does not open the link in the app. I am…