Financial Services
Discussion List
-
Best practice questionIn Using SmartsheetHello, I'm new to Smartsheet as of this week and am getting the hang of things, so please bear with me: What I have: * Large datacenter project involving nine teams* technology inventory for each team * Risk Register report * Migration …
-
Nested IF statement with CheckboxIn Formulas and FunctionsI have 3 fields. 2 fields are checkboxes and 1 is text. Active (checkbox) Not Active (checkbox) Complete (Yes/No) I want to write a nested IF statement that if either are checked it provides a Yes / No response. IF(ACTIVE = TRUE, &…
-
Dashboard formula counting rows within date rangeIn Formulas and FunctionsFirst post, Longtime SSheet user but new to formulas and stuck on this last one for a dashboard. I am trying to count rows where the due date is within a range, the form created date is within 14 days of the due date and the status is no…
-
Radar ChartsIn Using SmartsheetHi, I think the graphs implemented last year were an excellent and needed set of features. I still however have to use PowerBI for some of our charts. This is problematic. Can we get Radar Charts into the Graph Types?
-
nested ifs with greater than less than- #unparseableIn Formulas and FunctionsWrestled with this enough. Need to call in a friend. Can anyone figure out what is wrong with my formula? =IF([Last review date]1> 365), "Red", IF(AND([Last review date]1 < 365, [Last review date]1 > 275), "Ye…
-
Help using join & collect function with multiple criteria & having the delimiter be a semi-colon andIn Formulas and FunctionsI've been able to successfully use join and collect function with 1 criteria, but not two and am also curious if I can have the results within a cell space to look like Ctrl+Enter was used after each one to be able to easily read through a…
-
Can a range be specified with a beginning and no end?In Using SmartsheetI'd like to create summary rows at the top of my sheet, but specifying the entire column as a range in the formula is causing #circular reference and #block errors. Is there a way to specify a range from row 25 to infinity? I'd like addi…
-
Matching multiple values from multiple columns in linked sheet to fill cell with content from thirdIn Formulas and FunctionsI have Two sheets, one that acts as a "Rate card", it is broken down into Job title / Location / Day rate and the second is a budget sheet. For Example, Rate Card Column 1 / Column 2 / Column 3 Project Manager / UK / £10 Proj…
-
Formula to look across rows and columns in a table.In Using SmartsheetHi there I need a formula that will look across rows and columns in a table. For example, I need the result for School District-B with 23 items. The result from the table below should populate with: $350 …
-
Multiple criteria in a row for VLOOKUPIn Formulas and FunctionsI am trying to create a report from data with multiple criteria in a row. The objective is to return the residual risk value for each combination of risk + strategic initiative. In Excel, I was able to accomplish what I am looking for with…
