Finance
Discussion List
-
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…
-
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 99 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 61 views 1 comment 0 points Most recent by Andrée Starå Formulas and Functions
-
Dashboard Sharing: Is there a way to check all the Dashboards I currently have published?In Using SmartsheetHello, I've created a few Dashboards and published them for viewing. After viewed, I removed the publish option in order to stop anyone from acessing them. Is there a way to check all the Dashboards I currently have published? I wanted to …