Discussion List

  • Restricting Text/Number Columns to a Format
    In Using Smartsheet
    Hello all, I have dug around enough to be certain that there is no feature to restrict a column to a certain data type (i.e. restricting a text/number column to only be 6 numeric digits). This is something that would be extremely useful t…
    391 2
    391 views 2 comments Most recent by Caroline Sheldon 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…
    1594 5
    1.6K views 5 comments Most recent by L_123 Formulas and Functions
  • Auto Delete rows
    In Using Smartsheet
    HI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
    1254 9
    1.3K views 9 comments Most recent by Genevieve P. Using Smartsheet
  • Master Contact List for use across sheets in a workspace
    In Using Smartsheet
    I have 16 grids that all use a Contact List with 23 of the same client contacts.  (1) its a HUGE waste of time to have to populate 23 contacts into a list 16 times and (2) every time a new person joins or leaves the team, I have to go into…
    821 16
    821 views 16 comments Most recent by Paul Newcome Using Smartsheet
  • Power BI
    In Using Smartsheet
    Has anyone used Power BI with Smartsheet? I do a lot of things in Smartsheet, and we have another department doing things in Power BI.  I see articles in Smartsheet about Power BI, but not sure what that means or if I have opportunities I…
    193 5
    193 views 5 comments Most recent by Kelsey Miller Using Smartsheet
  • Separate notifications for added rows
    In Using Smartsheet
    Hi, I want to create a separate notifications for each row that is added when certain conditions apply. I'm sharing a screenshot of how the notification is set up. The issue that I have is that if more than one row is added before saving…
    122 8
    122 views 8 comments Most recent by ker9 Using Smartsheet
  • Default Sheet Displayed when opening Smartsheet
    In Using Smartsheet
    With the old UI, the object (sheet) that was opened when we closed Smartsheet was displayed when we opened Smartsheet the next time; however, with the new UI, this seems to be hit and miss.  Is there a way to set a object (sheet) to be the…
    274 3
    274 views 3 comments Most recent by BHN Admin Using Smartsheet
  • Problem with vlookup calculations
    In Formulas and Functions
    I am having a new problem with an existing Smartsheet that has worked fine until now. Existing workflows have stopped working. The problem does not appear to be workflow, but something else going on. We have a workflow that triggers off of…
    538 7
    538 views 7 comments Most recent by Kyle Van Pelt Formulas and Functions
  • 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 …
    369 4
    369 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…
    166 3
    166 views 3 comments Most recent by Brianne Laird Formulas and Functions