Sheets

Discussion List

  • Imported Formulas from Excel
    In Formulas and Functions
    Happy Wednesday! I have been going in circles trying to figure out where this formula is going unparseable. I researched it against other similar (working) formulas in smartsheet and the Formula errors guidance- but I am still missing it…
    Answered - Pending Review
    12 5
    Answered - Pending Review 12 views 5 comments Most recent by Cat Werbeck Formulas and Functions
  • Gathering data from 1000 sheets
    In Using Smartsheet
    Hello, i have this question: We have more then 1000 sheets with some project progress calculated in certain cell. Then we have one master tracking sheet with 1 line = 1 project. What i need is: Link this progress number from each sheet to …
    Accepted
    10 2
    Accepted Answer 10 views 2 comments Most recent by Daniel Dragoun Using Smartsheet
  • Tracking date when a drop down value is selected
    In Formulas and Functions
    I'm creating a project tracker where I can assign what phase the project is at (design, prototype and complete). What I want to do is track how long the project is in each phase, so what I plan on doing is tracking when the drop down items…
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by Cole Fuerste Formulas and Functions
  • Pasting Data Set
    In Formulas and Functions
    Hi, I have a large data set that I paste into Smartsheet from excel for a Dashboard to populate. When I paste some of the data in that's in 1 cell in excel Smartsheet is splitting it across multiple columns meaning I manually have to amen…
    Answered - Pending Review
    2 4
    Answered - Pending Review 2 views 4 comments Most recent by Maxine Roberts Formulas and Functions
  • Is there any way to select only specific columns to be included in alert messages that are sent out
    In Using Smartsheet
    Is there any way to select only specific columns to be included in alert messages that are sent out using the SmartSheet Automation feature? Currently, I set up an alert. And it displays all of the columns, even if I hide certain columns …
    142 views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Index/Match
    In Formulas and Functions
    I have a smartsheet that has a column for "State" and then a column for "Territory". How do I write a function that if a row within column "State" equals say "TX" than the column for "Territory&…
    Answered - Pending Review
    12 3
    Answered - Pending Review 12 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Can you use Groups in Contact list column type?
    In Using Smartsheet
    We have different groups created under user management, for example, email team, marketing team etc. I wanted to know if they can be used inside a column with contact list column type for a project? If yes, how? If not, what exactly is the…
    Accepted
    2 3
    Accepted Answer 2 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Can I combine multiple rows into one row on a Gantt Chart?
    In Using Smartsheet
    Dear all, I want to aggregate multiple project schedules into a master schedule. When copying the milestones from various projects into a single sheet, my overall Gantt Chart displays an event as a row, and each project occupies many rows.…
    Accepted
    142 8
    Accepted Answer 142 views 8 comments Most recent by Tiffany Talsma Using Smartsheet
  • Lock or Store Date/Value Solution without using Zapier
    In Formulas and Functions
    Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sh…
    609 views 15 comments Most recent by kellyj Formulas and Functions