Financial Services

Discussion List

  • If with dropdown list
    In Formulas and Functions
    I'm trying to come up with the formula to dropdown only certain countries if chose certain region. I have two dropdown columns Region and Country If chose Region EMEA, country dropdown list will show DE, DK, NO If chose Region APAC, cou…
    42 4
    42 views 4 comments Most recent by Paul Newcome Formulas and Functions
  • Hello
    In Using Smartsheet
    Hello all Im new to the community and I'm hoping to be able to collaborate with you all on specific topics that may arise throughout our business community.
    11 views 2 comments Most recent by Mike Wilday Using Smartsheet
  • Formula
    In Formulas and Functions
    HI Team, Do we have substitute to these symbol in Smartsheet or how we can use these function in Smartsheet ">" & i have build this formula in excel and its working fine, but i am getting error in smartsheet   IF(K$1…
    21 1
    21 views 1 comment Most recent by Andrée Starå Formulas and Functions
  • How to right-size a Project Portfolio?
    In Using Smartsheet
    This question may be more on Project Management and Culture than it is solutioning in Smartsheet Software, but possibly some of you have done something creative in Smartsheet to help your organization. I have been with my organization for…
    11 3
    11 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • Licensed User to send an email for a row?
    In Using Smartsheet
    Do you have to be a licensed user to email a row? If that was one of the "new" changes for the unlicensed user, I did not see it in the email.
    11 views 3 comments Most recent by Paul Newcome Using Smartsheet
  • cell.format currency settings
    In API & Developers
    I'm able to successfully format a cell through the API and the compact format string, cell.format (https://smartsheet-platform.github.io/api-docs/#formatting,) except for cells with currency formats. I would like to see an example of the …
    147 3
    147 views 3 comments Most recent by Alejandra API & Developers
  • Counting cells with formulas
    In Formulas and Functions
    My underlying issue is that I'm trying to count cells that begin with a certain number.  The data that is present in my SubCategory column is a picklist.  Examples: * 106 COST BILLED IN ERROR * 110 FAILURE TO PURSUE PAYMENT AFTER INVOICE …
    32 views 3 comments Most recent by Paul Newcome Formulas and Functions
  • Prorated Rent Schedule Formula Help
    In Formulas and Functions
    Need a formula to calculate what is due per calendar year when the rent amount changes year to year (midyear)   Any help appreciated! 06/01/19-05/31/20 Total Rent Due: $175,000 06/01/20-05/31/21 Total Rent Due: $200,000 Total Rent of 20…
    21 views 1 comment Most recent by Paul Newcome Formulas and Functions
  • Nonworking Days but tasks must be completed
    In Using Smartsheet
    So I'm setting up a smart sheet so that I have a holiday break for Christmas and Thanksgiving.  My problem I'm having is that when I go to start one task after the next, it'll start a task and carry it through the holiday break then comple…
    11 1
    11 views 1 comment Most recent by Paul Newcome Using Smartsheet
  • Report Builder and Sheet Summary Report - Auto add new sheets
    In Using Smartsheet
    I successfully use the Sheet Summary Report - however, when I deploy a new Workspace, I must manually go back to the Report Builder and add the sheets that I want included in the Sheet Summary Report. Ideally, a Sheet Summary Report would…
    81 views 3 comments Most recent by Andrée Starå Using Smartsheet