Discussion List

  • How do I create a summary page or report from a Financial Donor List?
    In Formulas and Functions
    Hello, I have a sheet that tracks donations as they are received; name, email, and amount of the donation. Some are one time donors, others are repeat donors, and I would like to create a summary page that lists each individual donor and …
    Answered - Pending Review
    49 4
    Answered - Pending Review 49 views 4 comments Most recent by Andrée Starå Formulas and Functions
  • Combining Two Sheets into a Report
    In Using Smartsheet
    I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - w…
    3300 11
    3.3K views 11 comments Most recent by Andrée Starå Using Smartsheet
  • Are there Smartsheet Developers for Contract? If so, where?
    In API & Developers
    Hi, My company has been using Smartsheet for the better part of 3 years now. Some staffers have had training but nothing too extensive. My company recently merged both the Communications and Marketing departments and I have been tasked wi…
    Answered - Pending Review
    57 1
    Answered - Pending Review 57 views 1 comment Most recent by Andrée Starå API & Developers
  • Email User Completed Form
    In Using Smartsheet
    I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address.  I would like to create workflow automation when a certain trigger has taken pla…
    240 3
    Answered ✓ 240 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • How can I automate a subtraction
    In Formulas and Functions
    Hey, How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machine each time a row is added? Thanks i…
    1669 16
    Answered ✓ 1.7K views 16 comments Most recent by Paul Newcome Formulas and Functions
  • Access Security for Forms
    In Using Smartsheet
    Does anyone know if there's a way to limit form access to a specific person or group of people.  Or, is there something in the works at Smartsheet to address this?  Looks like there is currently two options. * Anyone * Anyone with a Smart…
    682 6
    682 views 6 comments Most recent by Lushenkm Using Smartsheet
  • Multiple conditions (from different columns) applying conditional formatting
    In Formulas and Functions
    1 Can I do conditional formating using more than one criteria (different Columns) We track goals for residents and if the goal is not met within the required timeline I would like it to highlight the total in red. is there a way to make 2 …
    Answered - Pending Review
    2149 3
    Answered - Pending Review 2.1K views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Dashboard Widget Chart Issue with Multi Select
    In Formulas and Functions
    I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing somethi…
    654 9
    654 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • Help with adding figures in different columns and row
    In Formulas and Functions
    I'm trying to add Q1 totals with the rest of the quarters of 2019. Here is the formula I'm using, but it isn't working. =[Q1 2019 NBR OF LOCATIONS]22 + [Q2 2019 NBR OF LOCATIONS]44 + [Q3 2019 NBR OF LOCATIONS]81 + [Q4 2019 NBR OF LOCATIONS…
    12 9
    Answered ✓ 12 views 9 comments Most recent by Paul Newcome Formulas and Functions
  • GLITCH? Text isn't wrapping nor doing a copy/paste correctly
    In Using Smartsheet
    Good morning, I've discovered that text is no longer behaving well within the cell. I'm see words cut off within the cell, whether or not the cell is formatted to wrap the text. Thus, it makes copying the text and pasting it wonky. I oft…
    169 3
    169 views 3 comments Most recent by ker9 Using Smartsheet