Discussion List

  • Sheet Roll-Up
    In Archived 2016 Posts
    I'm curious if there is a way to have a "higher level" sheet that pulls from other sheets.   That way, each individual on our team can have their own projects with greater detail and our supervisor can see a higher level view o…
    2893 15
    Closed 2.9K views 15 comments Most recent by [email protected] Archived 2016 Posts
  • Autofill Monday based on a deployment date
    In Using Smartsheet
    Hi - I have a "date of deployment column" that I would like to auto-populate the column to the left to be the Monday prior to that exact deployment date which I will be calling "Launch week date".  Also the the 3 colum…
    274 1
    274 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • Report not Matching Formula Issue
    In Formulas and Functions
    Hi, I have created a report to use on a dashboard for showing the number of job cards to print for our workshop. The report is shown below, and you can see that there are different amount of jobs to be printed for each workshop: You w…
    65 3
    65 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Move Row Automation
    In Using Smartsheet
    I am trying to create an automation that moves a row to another sheet based on a cell being changed to a specific value.  In my case when I select a vendor to assign that project request to, I want it to move to a sheet that is their queu…
    35 2
    35 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Does Smartsheet email support respond?
    In Using Smartsheet
    I have been using Smartsheets for about a year and don't seem to have much luck getting any response from Smartsheet support via email.  Recently noted when they introduced multi select drop downs that the dropdown fields do not appear whe…
    55 2
    55 views 2 comments Most recent by Andy H Using Smartsheet
  • IF / OR formula help
    In Formulas and Functions
    Hi community, hope somebody may be able to help. I am trying to link a % of completion column with a progress bar. Formula is as follows: =IF([% complete]1 = "0", "Empty", IF(OR([% complete]1 > "0", [% c…
    81 5
    81 views 5 comments Most recent by Mike Wilday Formulas and Functions
  • Selecting Multiple Values from a Dropdown List
    In Archived 2016 Posts
    I have created a "dropdown list" column and added the values. I want to be able to select multiple values from the list. How do I do that?   Thanks, Judith
    153 18
    Closed 153 views 18 comments Most recent by Cindy Van den Bremt Archived 2016 Posts
  • Content Approval Template
    In Using Smartsheet
    Hi Guys, Have us used a template that works well for you? Please share
    97 2
    97 views 2 comments Most recent by Andrée Starå Using Smartsheet
  • Dashboard Permissions to Report/Data
    In Using Smartsheet
    I have created a dashboard for our creative team that is set up so that only the person viewing the dashboard can see their metrics. That being said, I found out the hard way that they cannot see their data unless I share them out to the m…
    3 1
    3 views 1 comment Most recent by Alejandra Using Smartsheet
  • SUMIF(OR(???
    In Formulas and Functions
    I am trying to sum a column if either my Paid in 1st half in 2019 column is checked or my Paid in 2nd half in 2019 column is checked. I am trying to use a few different formulas without success. Here are a two that I've tried: =SUMIF(OR(…
    203 2
    203 views 2 comments Most recent by KaitlinH2 Formulas and Functions