Energy & Utilities


Discussion List

  • 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…
    1418 5
    1.4K views 5 comments Most recent by L_123 Formulas and Functions
  • Dashboard Template
    In Using Smartsheet
    I have multiple projects that have their respective project schedule sheets and I created a dashboard of one project. I was wondering if there was a way to make a template of that dashboard so that I could make the same dashboard for all o…
    787 4
    787 views 4 comments Most recent by Sam Gollon Using Smartsheet
  • Report on all sheets I am part of as Assigned To
    In Using Smartsheet
    Many of our team members will be allocated to many different sheets. 1. Is there a feature how to make a report showing all sheets I am assigned to?, and as a continuation a report showing specific tasks in those projects, for example Gat…
    323 5
    323 views 5 comments Most recent by Jose Maria Martinez Using Smartsheet
  • Count Number of Cells that Contain Certain Text?
    In Formulas and Functions
    Hello, I am trying to count the number of cells that contain certain words, such as "NYSEG" or "RGE," when the cells may contain more than one of these words. I have tried using =COUNT(FIND("ConEd", [Utiliti…
    1375 14
    1.4K views 14 comments Most recent by Genevieve P. Formulas and Functions
  • Date Stamp
    In Formulas and Functions
    Over the past couple of days, I have searched and read every article and even solicited help from SS and have worked myself in a circle. I have a drop-down list (Submitted, Approved, Declined), I need to "auto-populate" a date c…
    817 22
    817 views 22 comments Most recent by Mike Wilday Formulas and Functions
  • Array formulas
    In Formulas and Functions
    Hi, I was looking for using array formula functionality in smart sheet. I need this because i saw that like this i can full fill what i need. Any case, could you please mention if is a way to use array or other solutions in order to per…
    999 15
    999 views 15 comments Most recent by Paul Newcome Formulas and Functions
  • Conversations in Reports
    In Using Smartsheet
    I currently use reports tied to a central tracker to report out project updates to several different teams. Some of these projects require sharing of attachments and conversations about those attachments using the row's conversation tool. …
    389 4
    389 views 4 comments Most recent by David Lane 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…
    130 3
    130 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Formatting when exporting to pdf
    In Using Smartsheet
    Hi, Is it possible to create a pdf report based on one form entry? I know I can send an email confirming what has been entered on a form, however I would like to make this a pdf attachment rather than the body of the email. Lauren
    270 7
    270 views 7 comments Most recent by Andrée Starå Using Smartsheet