Discussion List

  • New Sheet -- Announcements Message
    In Using Smartsheet
    Hi, 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.
    53 2
    53 views 2 comments Most recent by Brianne Laird Using Smartsheet
  • Volunteer Allocation
    In Formulas and Functions
    Hi 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…
    64 3
    64 views 3 comments Most recent by Brianne Laird Formulas and Functions
  • Filtering on dashboards?
    In Formulas and Functions
    I'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…
    2352 35
    2.4K views 35 comments Most recent by Andrée Starå Formulas and Functions
  • Form Confirmation Options
    In Formulas and Functions
    I 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?
    704 4
    704 views 4 comments Most recent by Debbie Sawyer Formulas and Functions
  • Move Rows to Another Sheet...that contain formulas
    In Formulas and Functions
    Hello!  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…
    212 views 5 comments Most recent by Brianna Kempfer Formulas and Functions
  • Quickbooks & Smartsheet
    In API & Developers
    So. 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…
    1.6K views 16 comments Most recent by Michael Humenansky API & Developers
  • Calculating costs for a task over more than one month
    In Formulas and Functions
    I'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 2
    Answered - Pending Review 32 views 2 comments Most recent by Paul Newcome Formulas and Functions
  • Does Smartsheet allow the calculation of IRR?
    In Formulas and Functions
    I 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…
    11 3
    Accepted Answer 11 views 3 comments Most recent by Michael Mather Formulas and Functions
  • Financial Formula Help
    In Using Smartsheet
    I 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. 
    51 views 3 comments Most recent by Michael Mather Using Smartsheet
  • Nested SUMIF formulas across multiple sheets
    In Formulas and Functions
    I 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…
    41 2
    Accepted Answer 41 views 2 comments Most recent by Colleen Marshall Formulas and Functions