Financial Services
Discussion List
-
DAYS360 FormulaIn Formulas and FunctionsI'm trying to move various spreadsheets from Excel to Smartsheet but I keep needing the DAYS360 formula. It is very common to calculate loans based on 360 day years so monthly figures remain constant (at 30 days/mo). I was very surprise…
-
Countifs with findIn Using SmartsheetI have 2 columns (Stage) and (Courses) Courses is a multi dropdown, stage is a single drop down. I want to count how many people are invited to Fundamentals 1 vs how many have completed or certified in a rollup sheet. I am either gett…
-
Login and toggling between sheet very slowIn Using SmartsheetJust wondering if anyone has experienced similar issues, on login we are experiencing very slow response time, once logged in we are also experiencing delay when toggling between sheets. The curious thing is that this is only happening on…
-
If with dropdown listIn Formulas and FunctionsI'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…
-
HelloIn Using SmartsheetHello 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.
-
FormulaIn Formulas and FunctionsHI 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…
-
How to right-size a Project Portfolio?In Using SmartsheetThis 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…
-
Licensed User to send an email for a row?In Using SmartsheetDo 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.
-
cell.format currency settingsIn API & DevelopersI'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 …
-
Counting cells with formulasIn Formulas and FunctionsMy 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 …