Finance
Discussion List
-
Sharing only certain data for edit on sheet.In Using SmartsheetHi, I got 5 sales reps that all log their new customer in rows on a master sheet. Each row has an assign to column for each sales rep. How could I share this sheet to each one of the sales rep so that they can only see their customers an…
-
Dropdown list - Update from the dev team ?In Apps, Integrations, and Add OnsHi everyone, TL;DR : When will we be able to have dynamic dropdown for a column / field in a form? Is there a workaround? I can't think of a single project where this CAN'T be used... I'm using Smartsheet more and more to provide s…
-
Move Rows to Another Sheet...that contain formulasIn Formulas and FunctionsHello! 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…
-
RYG Arrow ColorsIn Using SmartsheetI would like to recommend an additional option to swap the red and green arrows so that there is an option for red arrow = up and green arrow = down. This is helpful for budgeting in project management where at a quick glance you can see …
-
Overlapping Labels on Bar ChartsIn Apps, Integrations, and Add OnsI am using a stacked bar graph in order to show a breakdown of projected costs and where they come from. However, when using Data Labels, the totals and highest portion overlap. So far I have not been able to find a way to move labels arou…
-
New Sheet -- Announcements MessageIn Using SmartsheetHi, 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.
-
Volunteer AllocationIn Formulas and FunctionsHi 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…
-
Form Confirmation OptionsIn Formulas and FunctionsI 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?
-
Calculating costs for a task over more than one monthIn Formulas and FunctionsI'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 228 views 2 comments 0 points Most recent by Paul Newcome Formulas and Functions
-
Does Smartsheet allow the calculation of IRR?In Formulas and FunctionsI 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…