Discussion List

  • Track inventory movement in multiple warehouse locations
    In Formulas and Functions
    Hi, We would like to track inventory movement between multiple warehouse locations, there is no need to track stock value/sales, just need to track inventory movement between locations and the inventory balance Warehouse: Warehouse A, War…
    Answered - Pending Review
    34 2
    Answered - Pending Review 34 views 2 comments Most recent by Ashley356 Formulas and Functions
  • Nested If SmartSheet Formula For Symbols (R, G, Y)
    In Using Smartsheet
    =IF([% Complete]@row < 0.7, "Red", (IF([% Complete]@row = 1, "Green", "Yellow"))) i.e. =IF(data < number, "TRUE Symbol Text", (IF(data = number, "TRUE Symbol Text", "FALSE Symbo…
    22 1
    22 views 1 comment Most recent by Kelly Moore Using Smartsheet
  • 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 …
    4875 13
    4.9K 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
    16 1
    Answered - Pending Review 16 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
    34 1
    Answered - Pending Review 34 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
    17 1
    Answered - Pending Review 17 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
    23 1
    Answered - Pending Review 23 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
    35 1
    Answered - Pending Review 35 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…
    201 6
    201 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…
    1409 5
    1.4K views 5 comments Most recent by L_123 Formulas and Functions