IT & Operations

Discussion List

  • Filter tables based on dropdown menu selection
    In Formulas and Functions
    Hi all. I've been tasked with mapping some data key connections between a large number of tables. I am looking for a way to display only the tables that match criteria from a single-select dropdown menu. Some pictures are below to illustra…
    Accepted
    24 3
    Accepted Answer 24 views 3 comments Most recent by Andrée Starå Formulas and Functions
  • Row height issue
    In Using Smartsheet
    I know that row height can not be manually adjusted like in excel, that's usually no problem. In my case, one sheet has had some select rows height change, as if someone wrapped/unwrapped text or changed the text positioning but the format…
    1090 4
    1.1K views 4 comments Most recent by Joost Using Smartsheet
  • How to List Parents By Common Child
    In Formulas and Functions
    I am working on a project book of work and currently have a list of resources listed by project: Project 1: Rich John Angela Carly Ted Project 2: Tim Jeff Rich Ted Project 3: Sam Tim Ted I am looking to create another sheet that will auto…
    Answered - Pending Review
    32 6
    Answered - Pending Review 32 views 6 comments Most recent by Genevieve P. Formulas and Functions
  • Calculate cumulative duration of time spent in each status where status changes are bidirectional
    In Formulas and Functions
    Hi, I have a problem I am trying to solve in a sheet that contains hundreds of individual requests. Each request starts with Status = 'New' and finishes at Status = "Complete" in between there are 3 review statuses, "Review …
    Answered - Pending Review
    31 5
    Answered - Pending Review 31 views 5 comments Most recent by Andrée Starå Formulas and Functions
  • Card View for Reports
    In Using Smartsheet
    All,  Has there been any progress with adding card view to reports?  Has this been an approved feature and scheduled for a release? Our company has been pushing a move to JIRA because of the gap with smartsheet in allowing our teams to vi…
    3859 38
    3.9K views 38 comments Most recent by Frank Falco Using Smartsheet
  • Integration with Converse.ai
    In Using Smartsheet
    Hi, I am building a bot on Converse.ai. How can I integrate smartsheet into my bot? I specifically want my customers to be filling out forms at a certain stage of the bot  Thanks, 
    42 6
    42 views 6 comments Most recent by Andrée Starå Using Smartsheet
  • Need report to prompt for string search
    In Using Smartsheet
    Hi, I am creating a sheet tracking City's address modifications. There should be a report where users can see if there already were rows with similar address. Hope there is a way to enter a search string for report to show rows whose addr…
    22 2
    22 views 2 comments Most recent by Patrick Bonahoom Using Smartsheet
  • CTRL + ] Does Not Indent, But Right Clicking Does
    In Using Smartsheet
    Our Senior VP is having an issue with a sheet where she is unable to indent a row to be a child/sub-task. The strange thing is she is able to right click and indent it, but not using the keyboard shortcut. The keys are working just fine (…
    216 10
    216 views 10 comments Most recent by Rune Østerhus Using Smartsheet
  • Looking to count the number of Stars
    In Using Smartsheet
    Hello all, I'm looking to count the number of "stars" within a column and have been testing with =COUNTIF(check_column, "true").  This isn't working.  Any ideas?
    233 7
    233 views 7 comments Most recent by Andrée Starå Using Smartsheet