Discussion List

  • Attachment in an online Form
    In Using Smartsheet
    Hello, I have creeated an online form but I need that people can add an attachment (image). Anyone knows if this is possible and how?  I guess it is possible as this form I am filling in has  this feature. Thanks you for your help Ugo …
    6152 13
    6.2K views 13 comments Most recent by bruno.benavides Using Smartsheet
  • It there a formula to use so that I can calculate an amount between dates?
    In Formulas and Functions
    Hi! I am trying to calculate the amount outstanding between certain dates, but I can't figure out what to use or if that is even possible.
    Answered - Pending Review
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Kelly Moore Formulas and Functions
  • One Project - Multiple Clients
    In Using Smartsheet
    I have one project where certain tasks are paid by one client and the remaining paid by a another. Example: Data collection paid by Client A, Data Cleaning paid by Client B How would I set this up so when the smartsheet project is linke…
    Answered - Pending Review
    43 1
    Answered - Pending Review 43 views 1 comment Most recent by Genevieve P. Using Smartsheet
  • how to extract currency from a string of text
    In Formulas and Functions
    similar to a bank statement 07-22 Point Of Sale Withdrawal MARTYS FI 61 MAIN 13.99 - SHOPKINTON MAUS 07-22 Point Of Sale Withdrawal PAN THAI 44.38 - RESTAURANTHOPKINTON MAUS 07-22 Point Of Sale Withdrawal ALS STATE STREET 10.00 - CABOSTON …
    Answered - Pending Review
    22 1
    Answered - Pending Review 22 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • How to calculate time in smartsheet
    In Using Smartsheet
    Hi, How to calculate difference in time in smartsheet for example Start Time = 12:23:20 and End Time = 20:23:20 I want the difference between this two time in third column = 8:00:00
    Answered - Pending Review
    50 1
    Answered - Pending Review 50 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • INDEX/MATCH function doesn't return exact match.
    In Formulas and Functions
    I'm having and issue with the MATCH function not returning an exact match. If my understanding of the formula is correct: "1" for the [search_type] should find the first value greater than or equal to the search_value starting f…
    Answered - Pending Review
    87 1
    Answered - Pending Review 87 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Certification Exam
    In Using Smartsheet
    I took the certification exam back in January as an "early adopter" for my team.  Some of the other members are now getting around to taking it and asked me about the practical component (part II) where you have to send off a fil…
    416 6
    416 views 6 comments Most recent by BatmansKnight 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…
    1585 5
    1.6K views 5 comments Most recent by L_123 Formulas and Functions
  • Hierrarchy in web forms
    In Using Smartsheet
    I have data broken out by region (AMER, EMEA, & APAC), and there is budget information contained in each row.  The region is a parent and the corresponding rows are children.  This allows me to get a regional budget summary. Is there …
    444 6
    444 views 6 comments Most recent by Malorie Scaramozi Using Smartsheet
  • How to calcualate time difference
    In Formulas and Functions
    Hi Team, How to calculate time difference 10:00:30 AM Start Time - 11:12:00 AM Regards,
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Parker Oxford Formulas and Functions