Financial Services

Discussion List

  • Document Management Systems
    In API & Developers
    Hello All, We are using SS and considering DMS options (Efilecabinet, Box, M-file) to manage the bulk of docs we handle in the process. Wondering if anyone in the community that has a DMS in place can provide feedback or advice on their …
    133 4
    133 views 4 comments Most recent by Brianne Laird API & Developers
  • 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…
    2359 35
    2.4K views 35 comments Most recent by Andrée Starå Formulas and Functions
  • Why is my multiplication formula invalid?
    In Formulas and Functions
    I am trying to create a column that multiplies the total hours by the pay rate of certain staff. In the pay rate column I have used the formula =IF(Name1 = "Sophie", "25.54", IF(Name1 = "Peta", "55",…
    Accepted
    4 1
    Accepted Answer 4 views 1 comment Most recent by David Joyeuse Formulas and Functions
  • Link Reference Sheet Dropdown
    In Formulas and Functions
    Is it possible to reference a list on a separate sheet for the user to select as they input data into rows?For example; activity type, client name? I have created a time sheet and would like users to reference the data in another sheet. …
    3486 22
    3.5K views 22 comments Most recent by Genevieve P Formulas and Functions
  • Using Smart Sheet and Web Form to manage testing
    In Using Smartsheet
    Hi, Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering) across multiple users performing sam…
    276 7
    276 views 7 comments Most recent by Andrée Starå Using Smartsheet
  • Resource View by Project
    In Using Smartsheet
    Hi I wonder if anyone might be able to shed some light on an issue I'm experiencing. I'm a new Smartsheet user so I could well be doing something wrong or expecting Smartsheet to work in a way that it doesn't. I'll set out the issue below…
    541 6
    541 views 6 comments Most recent by Rex Clark Using Smartsheet
  • Smartsheet Dashboard published within MS Sharepoint 2016
    In Using Smartsheet
    I want to take a Smartsheet Dashboard that is interactive and put it as a web part within MS SharePoint 2016 site.  I use the page viewer webpart and provide the web page link offered up when I publish the dashboard, but once I apply it, a…
    1007 5
    1K views 5 comments Most recent by Jill Garance Using Smartsheet
  • There´s a way to copy a row to another sheet with a if formula?
    In Formulas and Functions
    Hi everyone, i have a group of four sheets and i want to copy specific rows to another sheet. I have a column called "FORMAL RECLAMACIÓN" and i want to copy the entire row to another sheet if there´s a date on this column. Is thi…
    Accepted
    11 2
    Accepted Answer 11 views 2 comments Most recent by Sebastian Avila Formulas and Functions
  • Calculate the time between two dates by days, hours and minutes
    In Formulas and Functions
    Hi, I am trying to implement the following formula from my excel spreadsheet into my smartsheet: =INT(O2-Q2)&" Days "&HOUR(MOD(O2-Q2,1))&" Hour "&MINUTE(MOD(O2-Q2,1))&" Minutes" Basicall…
    1307 25
    1.3K views 25 comments Most recent by remkin Formulas and Functions