Financial Services

Discussion List

  • Can you add a VAT field in a smartsheet?
    In Archived 2015 Posts
    I want to add a field that automatically works out the VAT in a seperate field so i can calculate how much VAT we pay on services. Is this possible?   I have tried to add a formula e.g =SUM(amount)*20% and also +=SUM(amount)*0.2 Neither…
    56 2
    Closed 56 views 2 comments Most recent by Anthony Henson Archived 2015 Posts
  • Drop Down Lists
    In Archived 2015 Posts
    I am new to smart sheets and way behind my fellow community members level.   I have a database spreadsheet for tracking new product development.   Question: can you incorporate a drop down list into a smartsheet.   Appreciate your ad…
    1222 2
    Closed 1.2K views 2 comments Most recent by JohnHinkle Archived 2015 Posts
  • Customize Smartsheet within an embedded portal
    In Archived 2015 Posts
    Can smartsheet have a template built and provided to our Clients from a web portal that they entered via user/pass. I know we can embed smartsheet. The situation is that I want each of them to have their own private sheet. Also, we want ac…
    236 5
    Closed 236 views 5 comments Most recent by Mark Sierra Archived 2015 Posts
  • Click to call with skype or google voice
    In Archived 2015 Posts
    Does anyone know how to get click to call to work in smartsheet?  I noticed that when I first logged into smartsheet, skype was able to make a call from a cell containing a phone number, then all the cells were no longer recognizable after…
    281 2
    Closed 281 views 2 comments Most recent by Daniel Thornton Archived 2015 Posts
  • Can you return a blank cell in a formula that isn't text?
    In Archived 2015 Posts
    Is it possible to return a blank cell which is then part of a formula that adds up with other cells to result in a monetary value?   =IF(MILEAGE6 > 50, (MILEAGE6 - 50) * [MILEAGE EXPENSE]$2) I want values between 0 and 50 to return a…
    536 4
    Closed 536 views 4 comments Most recent by Allie Archived 2015 Posts
  • Formulas not following over
    In Archived 2015 Posts
    When I input a claim from the web form, it appears somewhat down in my sheet, and no formulas.  This is also the case when I have a row with formulas, then I move it to another sheet with the same columns and formulas, but it appears in th…
    213 4
    Closed 213 views 4 comments Most recent by Daniel Thornton Archived 2015 Posts
  • Money format in cell not working
    In Archived 2015 Posts
    I am using this formula to output a fee based on gross loss for insurance claim.  The resulting total column shows proper dollar format when it is over $100,000 based on first IF statement.  When it is either of the following IF statements…
    175 1
    Closed 175 views 1 comment Most recent by Travis Archived 2015 Posts
  • Tip for Day to get the team to play.
    In Archived 2015 Posts
    One of the things that we have done as of late to speed the ability to work in the sheet and for people to move about in the sheet is hyperlink your sub sheets to your master sheet. The Hyperlink creates a fast way to go to anothe sheet wi…
    12 4
    Closed 12 views 4 comments Most recent by Charles DESCOTES Archived 2015 Posts