-
% of children
Hi, I want to calculate % of checked children in the sheet below, can anyone help me? https://app.smartsheet.com/b/publish?EQBCT=41482d287b58426b801642f8c4cd31f0 Niclas
-
Enhancement Request - Color Coded Tabs
It would be nice to be able to color code the tabs with an indicator on the left or right "ear" of the tab. I use letter prefixes to code for Report (R), Template (T) etc, colors would be a lot slicker.
-
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…
-
Contact list
Hi, Our sales representatives use the form below to report their customer activities: https://app.smartsheet.com/b/publish?EQBCT=7661b84339764a62ad8a0e6f8d803770 I need to make a contact list connected to all the sales representatives sheets so we can get a complete contact list with all sales activities. Does anyone now 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!
-
Running Multiple Projects on SS
Hey SS Community, I am involved with a company that currently has no central data base overviewing all projects. I want to put a system in place where the PMs can manage their own projects. Also a system where the sales, quoting and other teams can oversee how the projects unfold throughout the project life cycle. I…
-
Add plans / tiers
Smartsheet, could you please add a plan in between "Basic" and "Team" or at least give users the option to purchase individual sheets? The plans offer either too little or too much. I understand a lot more comes with Team, but all I need is more sheets...not branding, etc. Thanks!
-
Help: Using =IF and Replace
Hello All, I need help making a formula that will replace a cell with Static Information with a pre-assigned phrase when the information present in a row's range (IE [Room Assignment]22:[Room Assignment]50) matches cell's information. I'm lost on how to make this happen, and hope the solution is simple. I have a limited…
-
Using AND and ISBLANK in nested IF statement
I am responsible for tracking my companies incoming inquires and quotes. Did we get back to everyone, quote them, did they accept or decline the quote?, etc. As part of that I sweated out the following formula, =IF(ISBLANK([Follow Up Date]98), IF((TODAY() - Created98) - 2 > 0, IF(OR([Quote Accepted]98, [Quote Rejected]98,…