Finance
Discussion List
-
Track inventory movement in multiple warehouse locationsIn Formulas and FunctionsHi, 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 views 2 comments 0 points 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…
-
Attachment in an online FormIn Using SmartsheetHello, 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 …
-
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 16 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 17 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 35 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…
