Finance
Discussion List
-
Does Smartsheet allow the calculation of IRR?In Formulas and FunctionsI have found a key element of Program Management that needs solution in the Smartsheet platform. The calculation for IRR is critical component and not available as general function. As you may know, this simple one varying net cash flow ty…
-
Financial Formula HelpIn Using SmartsheetI am trying to get an IRR for a group's financial reporting. I know other software has this as a formula, but I do not see a way to recreate this in SS. Any help would be greatly appreciated.
-
Nested SUMIF formulas across multiple sheetsIn Formulas and FunctionsI am trying to create a couple of formulas that don't seem to be working properly. For the first sheet, I am creating a Document that lists Job titles and the hourly rate. Each job title can have multiple hourly rates. We will call this d…Accepted Answer 153 views 2 comments 0 points Most recent by Colleen Marshall Formulas and Functions
-
SUMIFS to Calculate Values for a Specific Year/Date RangeIn Using SmartsheetI am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or when I attempt to add data from a date r…
-
Cross Sheet Formula Limit ErrorIn Formulas and FunctionsI'm currently getting an error related to the cross-sheet formula limit. I'm not sure why I'm getting the error. So far I have referenced 6 columns in other sheets with SUMIFS formula. I received the error when I added the 2019 formula …
-
Automated Workflows and Charting Are Very PowerfulIn Apps, Integrations, and Add OnsMy Smartsheet application is going on six years old now and was in need of a rewrite after years of incremental improvements that used newly available capabilities in Smartsheet and as the needs of my company changed. My application basica…
-
Multi-select fields with INDEX/MATCH (or COLLECT) with multiple valuesIn Using SmartsheetHello fellow Smartsheet users! I am running into unique problem and more importantly finding the way to do something within Smartsheet. A little background. I build a request intake/workflow management tool for my Marketing department at …
-
Index(Match()): Lookup a price of a product from another sheet but keep historical entriesIn Formulas and FunctionsHi am am hoping to lookup a price of a product from another sheet based however keeping historical price changes. Smartsheet A: We have production runs of product XYZ listed in a sheet A. Based on a concat we want to lookup a product pric…Answered - Pending Review 63 views 3 comments 0 points Most recent by SoS | Dan Palenchar Formulas and Functions
-
Can I use an INDEX formula to retrieve value from another INDEX Formula?In Formulas and FunctionsHello, I have two similar INDEX formulas, where one works and the other one retrieves #INVALID VALUE error. They are as follows: "IF([Nov-19]188 = 0, 0, INDEX($[Jan-19]$119:$[FY50]$119, 1, [Nov-19]188))" - this one works and retr…
-
HOW TO SOLVE INDEX MATCH WITH DATE TENURE?In Formulas and FunctionsThis is Table 1 This is Table 2 The criteria is Match the Date & Name from Table 1 to find the Amount and put it in Table 2. And also add the amounts which is under the date tenure for the specific month. After many research I have fo…Answered - Pending Review 51 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
