Finance

 

Discussion List

  • 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
    10 1
    Answered - Pending Review 10 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
    26 1
    Answered - Pending Review 26 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
    13 1
    Answered - Pending Review 13 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
    14 1
    Answered - Pending Review 14 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
    23 1
    Answered - Pending Review 23 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…
    126 6
    126 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…
    1348 5
    1.3K 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 …
    396 6
    396 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
    12 1
    Answered - Pending Review 12 views 1 comment Most recent by Parker Oxford Formulas and Functions
  • Filtering on dashboards?
    In Formulas and Functions
    I'm new to smartsheet and trialing it at the moment. I have a question, I hope you can help me with: I have a portfolio of companies in a main sheet and their debt issues, and related stuff in several sheets. Rows are companies/debt issue…
    7018 53
    7K views 53 comments Most recent by Paul Newcome Formulas and Functions