Metals & Mining


Discussion List

  • Automate Export to Excel
    In Using Smartsheet
    I am looking at ways I can automate export a smartsheet to excel at regular frequencies. I tried using MS Flow, but the Smartsheet connector doesn't have an option to get to get the content. Any ideas?
    3624 7
    3.6K views 7 comments Most recent by Casey Lisak Using Smartsheet
  • Time Tracking - Hours and Minutes
    In Formulas and Functions
    I was working on a way to track some task hours and minutes... came up with this: One of the problems I ran into is that if you put "00" (double-ought) or any minute with a preceding zero, it would error. You can see the work-ar…
    1419 5
    1.4K views 5 comments Most recent by L_123 Formulas and Functions
  • Wrong date format on hyperlinks
    In Using Smartsheet
    Hello all,  I have searched this topic but can't find anything. I'm using UK date formats in my companies sheets and our account is set-up in UK format, however when I link a date from the source sheet into the new sheet the date is displ…
    171 6
    171 views 6 comments Most recent by Chris Kaliveas Using Smartsheet
  • Document Management Systems
    In API & Developers
    Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their …
    328 4
    328 views 4 comments Most recent by Brianne Laird API & Developers
  • Volunteer Allocation
    In Formulas and Functions
    Hi All,  I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
    131 3
    131 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Email User Completed Form
    In Using Smartsheet
    I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address.  I would like to create workflow automation when a certain trigger has taken pla…
    197 3
    Accepted Answer 197 views 3 comments Most recent by Andrée Starå Using Smartsheet
  • Automated update request not working
    In Using Smartsheet
    Hi, We are creating an automated workflow that requests an update thru a specific mail and it does not seem to work. Automated approval workflows work perfectly but update requests don't send the appropriate mail requested (eventhough in …
    505 7
    505 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • CMMS Build up
    In API & Developers
    Hello, Am working with a company as an IT which needs a CMMS tool for their mining clients for the WR, WO, PMs, AMs and so forth. And I need an expert of Smartsheet to help me on contract to develop the tool for them.
    34 2
    34 views 2 comments Most recent by Andrée Starå API & Developers
  • Is There Really No Built-in Log\NL Function?
    In Archived 2017 Posts
    My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula.  Are we missing something; Why is the SS math library so dumbed down?  Below is the formula in E…
    219 2
    Closed 219 views 2 comments Most recent by Ford Archived 2017 Posts
  • Nested If with Multiple Conditions Automation for Project Management
    In Formulas and Functions
    Hi SS Community!    Had a complicated question and my formula keeps coming back unparseable, so I wanted to run this by you and see if anybody could help me.  Currently, I have this:  =IF(AND([Start Date]@row < (TODAY() + 14)), NOT(…
    171 4
    171 views 4 comments Most recent by L_123 Formulas and Functions