functionality

Discussion List

  • 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
  • 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
  • how do you reference a single cell in an external sheet...dynamically? formulas? Cell Linking?
    In Using Smartsheet
    Thank you for your time. I cant find the answer in the documentation or forum. So I am asking. a. How do I reference a single cell in an external sheet? b. Can I reference a cell by row number and column number? c. Is there a …
    Answered - Pending Review
    62 5
    Answered - Pending Review 62 views 5 comments Most recent by Paul Newcome Using Smartsheet
  • Keeping track of dates
    In Formulas and Functions
    I want the time a specific cell is edited to be automatically placed in a cell. I don't want to use the column setting because that updates when any cell in the row updates and not just the one I want. Is there a way to do this?
    Answered - Pending Review
    2 1
    Answered - Pending Review 2 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • 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
  • #INVALID DATA TYPE Error
    In Formulas and Functions
    I am receiving an #INVALID DATA TYPE Error when I have blanks in the dates I am referencing. The formula is summing the equipment pieces based on the delivery month, but the delivery date can be added later in the project, so there will o…
    Accepted
    3 2
    Accepted Answer 3 views 2 comments Most recent by Angela Cisneros Formulas and Functions
  • 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
  • Prevent Sorting on Shared Sheet
    In Using Smartsheet
    We have a lot of users using Smartsheet as a tracker. Team members sort and then filter to get the information they need. The problem is that the sort affects all of the other users who are sorting on different things. Is there a way to ha…
    Answered - Pending Review
    23 4
    Answered - Pending Review 23 views 4 comments Most recent by Andrée Starå Using Smartsheet