Discussion List

  • Find highest value and return matching column header
    In Using Smartsheet
    Hi Everyone, I have to inspect several cavities in a process by using a Smartsheet form. Then, out of this database, I would like to know the highest and lowest cavity weight along with the cavity #. I wonder how can I do that. Here is …
    74 3
    Accepted Answer 74 views 3 comments Most recent by Isaac Gallardo Using Smartsheet
  • Baffled......Circular / Blocked Reference (Vlookup)
    In Formulas and Functions
    This one is baffling.  I have a problem with 2 sheets reading each others data through a Vlookup.  Each sheet has Vlookup ranges from the other sheet.  I understand why formula and Vlookup may return a #circular or #blocked reference, but …
    184 5
    184 views 5 comments Most recent by Paul Newcome Formulas and Functions
  • Filter View Access for certain users
    In Using Smartsheet
    Hi everyone, I am using Smartsheet to implement an AM (additive manufacturing) order tool for a SME, which uses AM for prototyping. Objective of that project is to directly set an order out of the CAD programm (STL-file, part specificatio…
    613 5
    613 views 5 comments Most recent by Andrée Starå Using Smartsheet
  • Timestamping
    In Formulas and Functions
    Hello. Is there currently anyway to do timestamping in Smartsheets?  For instance, timestamping a cell when a tick box cell is ticked? Thanks             Andrew  
    93 6
    93 views 6 comments Most recent by Mike Wilday Formulas and Functions
  • Workflow Question - Decline with An Attachment
    In Using Smartsheet
    Wondering if anybody encountered the same situation here.   I have a very simple mechanical drawing approval workflow that works fine if the approver only click on "Approve" or "Decline" button. The approval column w…
    251 11
    251 views 11 comments Most recent by Bonnie Haytcher Using Smartsheet
  • Digital Signature
    In Using Smartsheet
    Hi all,   I've searched for this topic, but i could not find directly what  i was looking for. Is there on Smartsheet any functionality for digital signature that doesn't require pairing our service with another software? All the solut…
    3690 10
    3.7K views 10 comments Most recent by Andrée Starå Using Smartsheet
    In Formulas and Functions
    Hi  =ROUND(SUMIF($[Pareto Category]$32:$[Pareto Category]558, Predecessors21, $[Actual (MHrs)]$32:$[Actual (MHrs)]558), 0) The above is my formula. It says, "IF the value in the Pareto Category column is the same as the value in th…
    268 2
    268 views 2 comments Most recent by Amy Scherer Formulas and Functions
  • Update Confirmation email limitations
    In Using Smartsheet
    Has anyone figured out a way to disable the update confirmation email that is sent following an update request? The email is confusing my user community because it links to a sheet they don't have access to. Is it possible to even change t…
    311 2
    311 views 2 comments Most recent by Caroline Sheldon Using Smartsheet
  • SUMIFS & FIND functionality with Summary Sheets
    In Formulas and Functions
    Hi All, I checked the archives and couldn't find a solution to my problem so I apologize if this has already been asked. I am trying to create a formula for my Summary Sheet that will provide the sum of dollar amounts but only if they are…
    CL- Profile Photo CL-
    297 3
    297 views 3 comments Most recent by Sinema Formulas and Functions
  • Reporting like pivot or sumif. How to roll up values by name or category?
    In Formulas and Functions
    Is there a way to combine cell entries and give the total assigned to that category? Ex.    Project Lead      Cost savings John                      $100 Mary                      $500 Bob                         $400 John           …
    552 5
    552 views 5 comments Most recent by Mailys Formulas and Functions