Consumer Products

Discussion List

  • Add row data to a separate sheet ONLY if a box is checked
    In Formulas and Functions
    Ok. After 1.5 hours of trying to figure this out myself, I am reaching out to the experts. I have multiple Smartsheet Forms feeding into one Master Data Sheet. Each row of incoming data is then assessed for approval based on certain cell …
    200 3
    200 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Countifs Formula using a date range given
    In Formulas and Functions
    I have long countifs formulas on a metrics sheet and is pulling all data from an archive sheet. One of the colums on the archive sheet is date. I need to limit the data count on the metric sheet to only count if is it in between (and incl…
    16 1
    16 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Tableau Online vs Server
    In Apps, Integrations, and Add Ons
    Looking to link a Tableau dashboard to my Smartsheet dashboard, but according to this link we have to use Tableau Online.  Will a link to Tableau Server also work?  All my testing is giving me an error for invalid URL so asking here. We do…
    268 4
    268 views 4 comments Most recent by Andrée Starå Apps, Integrations, and Add Ons
  • Salesforce Integration- Worth it?
    In Apps, Integrations, and Add Ons
    Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit …
    38 1
    38 views 1 comment Most recent by Nathan Lloyd Apps, Integrations, and Add Ons
  • Saving spreadsheets in workspace
    In Using Smartsheet
    Hi all, I could not find any thread with this specific problem, pardon me if there is one.... I created a new Workspace, and within that workspace i also created a single spreadsheet. So i start writting content on that spreadsheet, the…
    2 1
    2 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Tracking Progress
    In Using Smartsheet
    Is there a solution that can be shared to assist me in sharing progress at intervals? For examples, I have a dashboard that lists the projects and the % completion, at any given time.  I would like to have that dashboard, show (let's say…
    120 1
    120 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Database of information from one sheet to another
    In Using Smartsheet
    Hi all, I have a sheet that is a "database" of about 400 records.  I want other users to be able to input one column of that sheet (Media Company Dropdown) in a form or other sheet and for the next seven columns to autopopulate.…
    29 2
    29 views 2 comments Most recent by Paul Newcome Using Smartsheet
  • Current Month automatic
    In Using Smartsheet
    I am looking for an automatic way to generate reports that compare last month and current month.  I have 6 account sheets that show totals by month and category.  I would like to pull all 6 accounts into one sheet that shows last and curre…
    1018 2
    1K views 2 comments Most recent by Paul Newcome Using Smartsheet
  • Row indenting is not working
    In Archived 2015 Posts
    I am having problems indenting rows on my sheets.   I have parent rows that I would like to have child rows beneath. However, when I click the indent on the child rows, the cursor on the parent row is missing.   My cells have data, an…
    2048 5
    Closed 2K views 5 comments Most recent by Zuk Zukowski Archived 2015 Posts
  • Keeping persistent dates for status changes
    In Formulas and Functions
    Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done.  I'd like to track cycle times and throughput.  I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and…
    61 4
    61 views 4 comments Most recent by Andrée Starå Formulas and Functions