-
New Client Sheet Generator?
Hello, I have a Web Form which Account Managers complete when a new client is to be added to a 3rd party tool. This data transfers to a smartsheet where an email is sent to our 3rd party tool notifying them there is a new client. This data contains the client name, address, phone, email, and POC. At this point, I am…
-
Web forms and formulas
Good afternoon, I have a simple sheet for a balance sheet, and I'm needing to know if there's a way for the web form submission to be included in the formula in my sheet. The last row & column of the sheet houses the formula from previous lines, but when the web form submission is added, it goes to a new row, not the last…
-
Please expose Total Float data. Seriously.
Please expose each task's Total Float data. This would enable using critical path (zero float) as a report criteria AND allow teams to see which tasks are very nearly on the critical path (minimal float). Since smartsheet can color-code the critical path in the Gantt view, we know the total float data is already there. Low…
-
Count children rows only if items are not marked complete
I have a parent with 22 children. I can use a simple formula to calculate the total number of children ="Site-Wide" + " (" + COUNT(CHILDREN()) + ")" What if I only want to count the children that haven't been marked as completed i.e. tasks that are still open? I'm trying to use this formula but I'm getting an #Invalid…
-
Sorting/Filtering on the mobile site
Wehn my people use smartsheet on a phone or tablet they are not able to sort or filter a column. Is there something we are doing wrong or is this feature not available on a phone/tablet? If not, any work around ideas?
-
Android Calendar View
Tried searching but to no avail. Any updates or plans for calendar view for android app? I do see that calendar view is available for iphone users.
-
Can a shortcut be created for the Favorites folder?
Being able to shortcut straight to a specially -curated group of sheets (the Favorites), rather than an overwhelming list of every available sheet, is my aim. It seems the "CTRL + /" shortcut does not show the Favorites folder in its results. * * Can "CTRL + /" be changed to include Favorites? * Or, can a Favorites…
-
Drop down box on a webform
Hi there I have created a dropdown box on a webform on smartsheet. Firstly, does anyone know how to edit the drop down list once created? Secondly, I have noticed that completed answers on the webform are not feeding back to a master sheet if the answers were in a dropdown list. Any suggestions would be much appreciated.…
-
Integration with Leankit
Hi My team and I are currently using Leankit as an internal way of managing jobs. However, it is limited in its inability to create dependencies and properly plan out project tasks. I am currently looking into using Smartsheet for this purpose. Is there a way to integrate Leankit and Smartsheet? It would be great if the…
-
COUNTIF formula across Multiple Columns
I am trying to count the number of times an individual's name is input across multiple columns. For example, an individual may be an "Account Manager" on one project but a "Project Manager" on another. I want to count the total number of projects this individual is involved with, regardles the role. Below is the formula…