Discussion List

  • Automatic report creation with custom template
    In Using Smartsheet
    Hi! I am working on creating a report in which data is obtained using a Smartsheet form. For each new answer on the form, a new report or Dashboard must be created, which must have the format below. I wonder if there is any tool, API o…
    Answered - Pending Review
    35 2
    Answered - Pending Review 35 views 2 comments Most recent by Jefferson Ribeiro Using Smartsheet
  • Counting physical inventory while removing duplication...
    In Formulas and Functions
    I'm trying to count the number of unique pieces of equipment that are on my worksite. Each unit has a specific Unit Number listed in a sheet. Units that are On-Site are indicated by a green dot in another column. The tricky part for me is,…
    Answered - Pending Review
    64 4
    Answered - Pending Review 64 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Smartsheet for Pandemic Readiness- Dont Panic Prepare!
    In Staying on the Same Sheet
    IT departments must take the lead on pandemic response planning... Your Challenge COVID-19 still has a lot of unknowns. Despite efforts by international and regional health authorities, misinformation and misinterpretation of available inf…
    208 0
    208 views 0 comments Started by Thurman Jones Staying on the Same Sheet
  • Seven Most Current Entries for each Question for Each Location
    In Formulas and Functions
    Hi, I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION. Here's my Master Smartsheet. This is the formula I started using based on responses in the community: =INDEX({TEST Range 2}, MATCH(MAX(COLLECT({TEST R…
    Answered - Pending Review
    24 4
    Answered - Pending Review 24 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • At Risk Formula Update
    In Formulas and Functions
    Currently using the Onboarding Template Set and in the Sheet Onboarding timeline, I have the Risk flag set, the current formula is to flag if the end date is in the past and the status is not compete (for the row)formula is =IF(AND([End Da…
    184 2
    Answered ✓ 184 views 2 comments Most recent by Andrée Starå Formulas and Functions
  • Cell values export from one project to another
    In Using Smartsheet
    Hello, We are currently managing a construction project with smartsheet and have created a Gantt Diagram and a few Dashboard to monitor several KPIs. The dashboards are updated automatically with every changes in the master project and pro…
    41 7
    Answered ✓ 41 views 7 comments Most recent by Paul Newcome Using Smartsheet
  • Smartsheet moving rows
    In Using Smartsheet
    Hello everyone, Bit of a strange one. I have a master list of parent rows each having several children rows. For some reason the order of children rows is changing. I have checked the activity log and no one is editing it and there is no c…
    47 5
    47 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Percentage increasing by 100
    In Using Smartsheet
    Hi all, I have an issue where, when inputting a percentage into the %Complete column which accompanies the Gantt, it multiplies this percentage by 100! I.e. it turns 1 into 100% and 100 into 10,000% - screwing with the sheet. The strange t…
    Answered - Pending Review
    222 9
    Answered - Pending Review 222 views 9 comments Most recent by Paul Newcome Using Smartsheet
  • Will locking a parent row lock the children?
    In Formulas and Functions
    Hello, I am looking at creating a way to track monthly time sheets. Ideally, I would like to have parent rows for each month with numbered days beneath. In theory, I would like to have an option where the supervisor approves that month,…
    241 3
    Answered ✓ 241 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Formula to check box if cell contains Date OR Text
    In Using Smartsheet
    I have a nested formula that currently involves one check box be checked and three date columns to contain dates in order to check-mark as 'Complete.' However, I discovered one of the date columns involved may contain text from time to tim…
    4970 4
    Answered ✓ 5K views 4 comments Most recent by Paul Newcome Using Smartsheet