-
Adding tasks via mobile device
I find it really cumbersome for most to have to open each project and drill down to the specific parent or child, etc. to add a task. If someone opens a sheet and it has everything open it can be very intimidating. It would be nice if Smartsheet could be more intuitive and allow you to drill down to where you want to be,…
-
Raising the Flag
I want to raise the flag when I have a number in a cell that is >=0 but <4. how do I write a formula that will raise the flag and not include the blanks
-
Smartsheet Certification
Looking for advice on the best way to prepare for the certification? Any study guides or tips? How is the test? Thanks!
-
Publish sheet without comments
Is there a way to have the indent feature but to hide comments on a published sheet? I have a sheet that I want to share by publishing but I don't want comments to be visible because they contain sensitive data. I am using the indent feature which allows rows to be expanded and collapsed to show/hide rows. I see that I can…
-
Disclaimer
My office creates schedules for our customers which are intended to provide an overall estimate of time involved to ; but not a guarantee. We would like to include a conspicuous disclaimer or splash screen in some way to ensure that the intent is abundantly clear and the schedule is not mis-used. I have placed notes in…
-
Excluding Sheets in a Report
I'm a little confused, in some of my reports under the "Where?" I have a checkbox option that allows me to to report on all sheets excluding the ones I have checked. I'm trying to build a new report that is going to report on a majority of our sheets except a select few. I'd rather include them all and exclude the few…
-
Auto Change Color or send a Notification/Mail
Hi Everyone, As per the attached and formula, How can i add the formula if Week 43,43~52 below the stock Level, RYG ball become to red. Green above the stock level. I'm only know the formula for single column. =IF(ISBLANK([Stock Level]2), "Yellow", IF([Stock Level]2 <= [Week 43]2, "Green", IF([Stock Level]2 > [Week 43]2,…
-
Issues with opening some tabs in Smartsheet
For sometime I have had issues opening some tabs within our company smart sheet application. I had tried various ideas to try and resolve the issue. I have 4 tabs which I have been given access, in the beginning they opened just fine, it's in reason months I have had issues opening them. So the owner of the smartsheet just…
-
Update Form not allowing updates to columns with formulas
I have a sheet that have formulas in some columns and when the update request goes to the user the user does not have the ability to update those columns. Is this a known issue and can this be changed to allow updates to columns with formulas. See attached.
-
Dynamic Filter-based Update Requests
I set up filters for each task owner in my smartsheet, with specific criteria, (% Complete less than 100, start date is not in the future, etc.) to send update requests with only the tasks they need to report on at the time. Is there a way to create a dynamic automatic update request based on these filters? I currently…
