Finance
Discussion List
-
It there a formula to use so that I can calculate an amount between dates?In Formulas and FunctionsHi! 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 views 1 comment 0 points Most recent by Kelly Moore Formulas and Functions
-
One Project - Multiple ClientsIn Using SmartsheetI 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…
-
how to extract currency from a string of textIn Formulas and Functionssimilar 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 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
How to calculate time in smartsheetIn Using SmartsheetHi, 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
-
INDEX/MATCH function doesn't return exact match.In Formulas and FunctionsI'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 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Certification ExamIn Using SmartsheetI 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…
-
Time Tracking - Hours and MinutesIn Formulas and FunctionsI 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…
-
Hierrarchy in web formsIn Using SmartsheetI 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 …
-
How to calcualate time differenceIn Formulas and FunctionsHi Team, How to calculate time difference 10:00:30 AM Start Time - 11:12:00 AM Regards,Answered - Pending Review 12 views 1 comment 0 points Most recent by Parker Oxford Formulas and Functions
-
Filtering on dashboards?In Formulas and FunctionsI'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…
