-
VLOOKUP - random responses
Having trouble with random responses from VLOOKUP. What is puzzling is that all options have been copied or transferred the same way but give a different result, any help appreciated!
-
Pie Charts
I was eager to checkout the recently released Smartsheet Charts, I have produced a couple of Pie Charts based on some real time data but seem to have found that limited funtionality/formatability (e.g. Not able to re-position labels) restrict their actual use, please see screenshots below. I wondered if it's just me or…
-
Best practices / templates to create an NPS Form and Dashboard
Good afternoon, I need to create a form to measure Net Promoter Score (NPS) for our PMO office. I have samples for the questions, but I would like to know if anyone has experience building a form specifically to measure NPS. Any ideas/suggestions are welcome. Thanks! Silvana
-
Report that not required to manually adding up new project
Hi Team, Can someone help me how to create a report that doesn't require to manually add when we have multiple projects...Is there a way.? Regards, Tanveer
-
Using templates vs sheets in "template set"
Hi, I am creating template "sets" similar to what SmartSheet has created so that our workplan has the same related reports and dashboards for every project. Because we have a lot of users, I like the idea of having the main workplan in a template so that it cannot be overwritten. However, I noticed that in none of…
-
Filtering Columns in Reports
I have a master sheet which has data pertaining to different departments. From this master sheet, I'd like to show only the information relevant to a department to that department, and none of the other data. 1) How do I restrict the datas in the columns that have to be shown 2) If out of 4 child rows, 3 pertain to one…
-
Sales Pipeline - Period View
Hi, I have a few sheets of Sales Pipeline for each Manager. I have brought all of the estimates sales data together in a separate sheet and created a Dashboard using this. However, I would like to only see data relevant to the particular Financial Year in the dashboard. Any suggestions on how to go about this?
-
Combining data from 2 sheets
Hi I have created 2 sheets: Employee Onboarding Employee KRAs Both the above sheets have one common field: Employee ID. Now I want to create a report by referencing to this common data field (e.g., Employee ID) and "blend" the data from both the sheets. Can we accomplish this please? Thanks Nasir
-
Countif logic not working
Hi Team, I need a formula that should count the based on Priority High, Medium, Low . So if the priority is High and Status is Completed it should count the number on closed column if the priority is High and status is In progress,Hold its should count the number on open column like wise we have to do for Low and medium.…
-
Reporting Hierarchy
I have a sheet with several parent, child and grandchild rows. I'm creating a Report from this sheet but I am unable to filter and see child or grandchild wise. I have created a WBS System (1, 1.1, 1.1.1 -> Parent,Child,Grandchild) as well but unable to group/filter using this. Is there any work around for this?