-
Auto changing numbers
Hello, I'm having a strange issue, where I enter a lengthy number and then when I click out of the cell where I entered it, Smartsheet has changed it to a number immediately above or below the number I entered. When I double click in the cell, it shows me the original number I entered, then changes it again when I click…
-
Creating Governance and Structure around SS Implementation
Has anyone established best practices/documentation around governance and incorporating Smartsheet into existing operations? If so, would you be willing to share anything you've developed and/or talk over the phone? Thank you, Dean
-
Counting non blank cells in a row till first non blank.
I need to count blank cells in a row, left to right, till first non blank cell. the non blank cell may contain any character/s or digits. Any suggestions? For instance this formula will work to count blank cells till it finds X in row 1, columns 1-20, but not anything else: =MATCH("x", [Column1]1:[Culumn20]1, 0) - 1
-
Maintaining a list of small department's resources
My compny is small (about 15-20 resources with limited turnover). To allow all users to work` w1ith the same list of resources as I undestand it, because contact lists are not shared, each user (or maybe just PM) would need to create (or import) a list of names/emails that would then be available to assign to tasks using…
-
Smartsheet Labs - Map
Love the map feature as a quick and easy way to view all of my companies locations and break them down by state or any way we need. I wonder if there would be any way to get county lines include on the maps though.
-
Sales Pipeline Sheet information links to Project management sheet upon status change
Our company tracks sales opportunities and basic project management using Google Sheets. We would like to move this function to Smartsheets. Our basic process: (We design, fabricate and install elevator interiors) A new sales opportunity is logged into a googel sheet and given a status of "Bidding". We also input several…
-
How to remain logged in on mobile device
I find it frustrating that I have to re-authenticate everytime I pull out my phone on a project to check dates. Why can't SmartSheet remain logged in just like all my other apps?? Is there something I'm missing? I've done a search but don't find any threads on this problem. Andy
-
Resource utilization
I am having some interesting results enabling resource utilization. I created a project, enabled resource managment on Assigned to and % allocated. I over utilized myself intentionally to test. When looking in the resource view I dont show any resource allocation and the project I created doesnt show up at all. I can…
-
Project Roadmap on Calender view of report
Hello, I have a master project list sheet setup. I am attempting to create a project roadmap so we can look at the big picture. I was able to create a report that shows every Active, On Hold and Not start project. Here are my two issues: 1. The calendar view will only view out to 1 month, is that the limit or is it a…
-
Web form question
Does anyone know if the web form functionality will incorporate a slide bar rating scale? This exists in Surveymonkey and my Marketing team still uses Surveymonkey regularly because of this feature vs SmartSheet web forms. thanks!
