Discussion List

  • Duplicate Check
    In Using Smartsheet
    Hi,   I want to identify rows that have a duplicate entry in a column entitled "Bill Number". How can I create a workaround formula to notify me when there is a duplicate? I believe the best way is to use a checkbox column enti…
    1918 4
    1.9K views 4 comments Most recent by Andrée Starå Using Smartsheet
  • Calculate the time between two dates by days, hours and minutes
    In Formulas and Functions
    Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
    2831 26
    2.8K views 26 comments Most recent by Julie Barbeau Formulas and Functions
  • 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…
    1425 5
    1.4K views 5 comments Most recent by L_123 Formulas and Functions
  • Setting up Update Requests for a monthly/quarterly basis
    In Using Smartsheet
    I'm trying to create an Update Request notification for certain rows in my sheet, but to be sent out on either a quarterly or monthly basis. More specifics--I am in a legal dept at a mortgage company, and trying to track common questions o…
    22 2
    Accepted Answer 22 views 2 comments Most recent by Sam Clapp Using Smartsheet
  • Automated Workflows Limit
    In Using Smartsheet
    Hi  Is there any limit to how many "automated workflows" we can create in a single sheet? Asking because one of my projects is expected to have approx 30 automated workflows in it.  
    726 5
    726 views 5 comments Most recent by Leslie Merlino Using Smartsheet
  • Creating a Formula for Dates and Traffic Lights
    In Formulas and Functions
    Hi, all! Our office is new to the SmartSheet community.  I am having some trouble creating a formula for a sheet.  I have the following columns: * "Initial Contact" - formatted as a date * "30 Days Since Contact" - fo…
    886 11
    886 views 11 comments Most recent by Ess Formulas and Functions
  • CountIF with wild card
    In Formulas and Functions
    I'm trying to count the number of items in a column where part of the text shows.  Is there a way to do this?   For e.g., I'd like it to count up the number of rows from a column in which the words "ids" show up.  Keeping in mi…
    1132 7
    1.1K views 7 comments Most recent by Kelly Moore 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 …
    330 4
    330 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…
    133 3
    133 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Join Collect
    In Formulas and Functions
    Hi I'm trying to to create a sheet that tells me all of the timekeepers that work on a client from data from another sheet.  Currently I have sheet that list all of our clients and I will like to add a column that list all of the timekeep…
    264 3
    264 views 3 comments Most recent by David Joyeuse Formulas and Functions