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.

Archived 2017 Posts

Discussion List

  • How to enable users to view entire sheet, but only edit rows assigned to them
    In Archived 2017 Posts
    I want all the users in the dept to view the entire sheet, but only able to edit rows with their name in the "project owner" column. How can I do that?   We use one sheet to list all projects in our dept. So we are adding and r…
    2305 13
    Closed 2.3K views 13 comments Most recent by ffonse5109711
  • Transfer/Move/Copy Rows from one sheet to another, and keep formulas..?
    In Archived 2017 Posts
    I need to transfer rows from one sheet to another that contain formulas. I know that the simple copy and move options just transfer over the values of the cells, but I'm really hoping that someone has found a clever way around this. We've …
    490 5
    Closed 490 views 5 comments Most recent by MakeItHappen
  • Conditional Formatting for Kanban Card View
    In Archived 2017 Posts
    When looking at items in Card view, conditional formatting is an option but you can't apply the formats to the card view itself. Is there a way to change the color of card based on conditional formatting? Current apply to rules only work …
    2843 10
    Closed 2.8K views 10 comments Most recent by Zach B
  • Enhancement Request: Improvements for Contact List columns in Forms
    In Archived 2017 Posts
    When adding a Contact List column to a Form, if no contacts are listed in the column properties, the field shows up as a simple text entry. If contacts are added in the column properties, the entry changes to a drop down.  However, the dr…
    262 6
    Closed 262 views 6 comments Most recent by Caitlin Gaines
  • EOMONTH formula request
    In Archived 2017 Posts
    I would really like to see the EOMONTH formula. There is a way to do that with the current formulas, but as an example of how long it is, here is what's needed for setting a due date to the end of the current month if there are more than 1…
    775 7
    Closed 775 views 7 comments Most recent by J. Craig Williams
  • Could a task be assigned to a group of contacts?
    In Archived 2017 Posts
    I would be interested in sending reminders and notifications to a group of people. I don't see helpful including more columns to do so as the table will be too long. 
    1086 8
    Closed 1.1K views 8 comments Most recent by Kevin Ikeda
  • Need help with #Divide By Zero error
    In Archived 2017 Posts
    I am trying to calculate the average duration taken to complete a project for a date range. I get a “ #Divide By Zero “ error and would like to use IERROR function to get 0 when divided by 0 instead of the error message. Please see the for…
    2905 4
    Closed 2.9K views 4 comments Most recent by Andrée Starå
  • Nested IF Statement for Flagging Duplicates
    In Archived 2017 Posts
    Hi, I am looking to create a nested IF statement that allows me to look at multiple columns for duplicates. It is only true if there is a duplicate in each of the columns.  For Example: First             Last               Job Jeff    …
    2060 11
    Closed 2.1K views 11 comments Most recent by Andrée Starå
  • Formula to automate Parent date
    In Archived 2017 Posts
    I can't seem to locate the formula that auto-fills a Parent date with the last date entered for a Child line item.    It would be the same as the Start and End Date column parent cells, but those are system so I can't copy/paste the corr…
    810 2
    Closed 810 views 2 comments Most recent by Mark Lappegaard
  • Gannt Chart - multiple milestones on the same row
    In Archived 2017 Posts
    I want to set up a recurring set of weekly meetings over a 3 year project on a single row. So far the only way I see to do this is to have a separate row for each meeting....painful. I can do a roll-up, but it graphically shows as a contin…
    1069 5
    Closed 1.1K views 5 comments Most recent by Andrée Starå