Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Need help making a COUNTIFS NOT formula
Hi there - I want to count how many times column A shows Katie and Column B does NOT show "Completed" looking at a range of rows - I have no idea how to make that happen :( I can do the COUNTIFS over and over again for all the different things that column be could be that aren't "Completed" but it seems there should be an…
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?
Cell linking - finding the next empty row on another sheet
Hi, Looking for a way to link a cell in each new sheet to the 1st column of the next open row in a summary sheet. I have a template sheet and summary sheet. I would like to create a number of sheets from the template and then display some info from the sheet in one row on the summary sheet. It looks like this is commonly…
Result look up
Hi, I am a beginer at using Smartsheet however have been successful to date in creating a workable module for my sales team, however, within one of my module sheets I have a list sales attributed to sales staff which uses a Decision drop down list "yes" symbol indicating a sale has been completed. My question is, how can I…
returning a blanc and auto created dates
helpful friends, Please see screenshot. I have a formula in B that returns a 'o' when other cells are unpopulated and I wish to show a 'blank' can this be done? Also because I have createsd a formula that I have copied down the length of 'B', the 'Created' Column 'A' is auto populating with the date that I populated the…
Blank rows showing in printed view
Hi all, I am trying to print out my project plan on an A3 sheet showing my Gantt chart and the tasks. However, when I go to print, I see two blank rows at the bottom of my sheet showing which are not needed and I would ideally prefer for these not to be shown. How could I change my sheet to not show these two blank rows?…
Google Forms Error
Any idea how to fix this? Thank you
Integration With Survey Moneky?
Is there a way to export survey results from Survey Monkey directly to a SS sheet?
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…
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…
