-
Sheet/Report Limitations?
Hi everyone! I was wondering if this scenario is possible for sheets either using formulas or commands. Example, I have 3 sheets (pipelines) that lead to multiple reports. I have jobs ranging from 0-100 (intervals of 20) percent probability(of selling/sold) in the pipelines. I currently have reports that group the…
-
Report Enhancement Request
I would like to be able to reference filter criteria for reports from a single top level cell. My project and workaround/issue is below: I am in the manufacturing business. We have machining lines that have a number of operations: ill say on average its ~20 operations. Each operation has an operator that at the end of the…
-
Resource View issue
Hi, I would like to assign a resource to a project but the user name not appear on the enterprise list or my contacts list. If I add the user to my contacts don´t appear on the resource view. What could I do for this? thanks for your support
-
Tracking edits of one column only
I'm trying to track when end dates are changes in the project plan. I've added a system-generated column that will show when a whole row is modified, any way to limit that to one column? I need reporting capabilities that aren't possible with the activity log or cell activity functions. It also would be great if there was…
-
Rounding Up to nearest 50 or 100
Hi all, I'm trying to round up to nearest 50 or 100 in a smartsheet. So far, I have =IF(AND(Count1 < 50), "50", ROUND(Count1, -2)). However, this only account to values less than 100. I was hoping anyone could help me for values over 100 (i.e. 101 is rounded to 150 and 155 to 200).
-
Report Frustrations from SmartSheet
I have been using Smartsheet now for about 2 months. While I love it for so many reasons, I am frustrated too. I love being able to run the reports, there are so many great filters......why don't they just allow a function to add totals to the reports. Hence, when management asks me to report the sales numbers based on…
-
Average of a drop downbox item
Hello, I am currently working on a project that involves a Dropdown box that has 3 options, Not Started, In-progress and Completed. However, I would like to get the average status of the project, and the the formula I am currently using doesn't seem to be working properly so I was wondering if I could have some help. This…
-
Changing the Color of the Submit Button
I am looking for some help as I'm new to smartsheet and still learning the ropes. I have embeded a form into a Wix website for a client however I would like to change the colour of the 'Submit' button to fit in with the website aesthetic. Can anyone let me know if this is possible and if so, let me know how to edit this?…
-
Why does some text wrap in a cell whereas other text hides until mouseover?
Please see screenshot. See how Child Advocates CASA is mousing over (but text is not expanding the size of the cell)? Now look across from Aloft Santa Clara and you will see long notes... I gave on 8/13/18 until... etc. These expanded the cell rather than hiding (as I prefer) until mouseover. Perhaps there is a character…
-
Sorting Filtered Sheet
Does anyone know if there is a way that you can sort a filtered sheet without altering the sheet structure across the board? Thanking you in advance.
