Finance
Discussion List
-
New Sheet -- Announcements MessageIn Using SmartsheetHi, Is there a way to have a welcome screen or alert come up when a person goes into a sheet. I would like the sheets comments to pop up on new sheets or like an announcement on already existing sheets.
-
Volunteer AllocationIn Formulas and FunctionsHi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…
-
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…
-
Form Confirmation OptionsIn Formulas and FunctionsI have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
-
Move Rows to Another Sheet...that contain formulasIn Formulas and FunctionsHello! Has anybody had experience trying to automatically move a row containing formulas to a new sheet? I am trying to pre-populate cells with formulas that would apply on a different sheet so that they will be ready to go once moved ov…
-
Quickbooks & SmartsheetIn API & DevelopersSo. I've been working on this Quickbooks & Smartsheet Integration for a couple of years now for my own internal use. It has many application & the proof of concept exists and we use it. We use it for an approval process (for in…
-
Calculating costs for a task over more than one monthIn Formulas and FunctionsI'm trying to come up with a formula to calculate the labor costs per month in one sheet ( 12 columns, one for each month), by referencing another sheet, and referring to the start/finish columns of said task. E.g. Task 1: Start = Aug 27, …Answered - Pending Review 32 views 2 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
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…
