Search

Discussion List

  • System Column - Last Modified
    In Formulas and Functions
    Hi everyone! Im having issues with a status column. My goal is to update the status if a job has hit 10 days or more and has not been approved yet. I was going to trigger it by using the (system column) "Last Modified"  Here's …
    123 6
    123 views 6 comments Most recent by Andrée Starå Formulas and Functions
  • Searching a column in another sheet
    In Formulas and Functions
    Hi,   I'm trying to reference contact info from one sheet and have it show up in another as I type.  I want the second sheet to search a column as I type and match the contact name if it exists.  Does smartsheet have a vlookup or somethi…
    56 1
    56 views 1 comment Most recent by Alejandra Formulas and Functions
  • Forgot the name of a tool to use
    In Using Smartsheet
    Hi, I thought I saw something flash up awhile ago about a way to build a site/page or something like that that can be used to keep stuff on per project. Almost like a social media thing. I cannot remember the name of that to look it up so…
    23 1
    23 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • "Recently Opened" Navigation bar Question
    In Using Smartsheet
    Hello All, I have been a huge fan of the "recently opened" Navigation tab and have about 30 sheets pinned.  I do use various sheets at various times, however, and would like to rearrange the order of these sheets as well as be a…
    Iz Profile Photo Iz
    35 1
    35 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • find and replace text in an already created update request.
    In Using Smartsheet
    I have update requests set for each employee's annual review. I would like to change one bit of text in the preformatted email. Is there a way to do this? Specifically, the line reads: Contact Mary Beth or Jesse.  I would like to remove …
    MB Profile Photo MB
    61 9
    61 views 9 comments Most recent by Scott Willeke Using Smartsheet
  • Countifs with find
    In Using Smartsheet
    I have 2 columns  (Stage) and (Courses) Courses is a multi dropdown, stage is a single drop down.  I want to count how many people are invited to Fundamentals 1 vs how many have completed or certified in a rollup sheet. I am either gett…
    167 5
    167 views 5 comments Most recent by Paul Newcome Using Smartsheet
  • Comments - Keep important ones on top
    In Using Smartsheet
    Hello, Are we able to lock comments on rows or sheets do that they stay to the top?
    13 1
    13 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Filter sheet level attachments
    In Using Smartsheet
    Can anyone tell me how I can filter to show only sheet level attachments (i.e. attachments that are not attached to a specific row but instead are attached to a sheet)? At the moment I have to manually trawl through all attachments in the …
    13 1
    13 views 1 comment Most recent by Andrée Starå Using Smartsheet
  • Help with Vlookup + date
    In Formulas and Functions
    I explain, I need to create an expiration date from a drop-down menu where the different types of payments of my clients are informed. Example, if a customer's account is "up to date" it means that the due date will be the issue …
    268 4
    268 views 4 comments Most recent by Gerardo_Clarke Formulas and Functions
  • Filter suddenly not working
    In Formulas and Functions
    Hi All,   I have an issue of a filter not working that previously worked fine. The filter looks for cells in a column formatted for text/numbers. Here's an example of the data in the column: NLOND_3104-1 NLOND_3709-2 -2 -1 -2 NLO…
    295 3
    295 views 3 comments Most recent by Andrée Starå Formulas and Functions