-
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…
-
use of sheet as a blog or project update board
Is anybody using SS as a blog or project update board? We have both internal and external people to communicate with and intstead of trying to make sure everyone is looped in on an email, we were just brainstorming on how to use SS to keep everyone informed, but allow users to post. Somewhat like SharePoint? I was thinking…
-
history problem
I have a material tracking log that I have been keeping track of dates for various items. It is really important that I be able to track who and when items have been changed. I recently created a copy of the sheet and reset a bunch of the items in the orginal version. When I go into the old copied version none of the items…
-
Outlook Integration and Search Capabilities
I use the Outlook Integration to save emails from within my Outlook to SmartSheet. Love this feature! Because of the nature of our business, we have the same data in many rows and when I do a search in the Outlook SmartSheet integration (example, for "John Smith," this causes many rows to appear in the search results.…