-
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
-
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…
-
Nested SUMIFS each with multiple criteria
Hello, Diving right in to the problem at hand. I have one sheet that handles reagent requests from multiple departments and another sheet that contains all of the stock solutions these reagent requests are made from. I want successfully created a formula that works for 1 sumifs scenario. =[Request Vol (ml)]@row -…
-
Row/Column Level Access
I have sheet on which people from multiple departments will have access to. A couple of my requirements: 1) I'd like certain departments to be able to see only the data in specific columns only relevant to them. Is this possible? 2) There are 3-4 attachments that will be added to the rows. I do not want departments having…
-
Smartsheet dashboard view
Hi Team, Can anyone suggest me how to create this kind of view in smartsheet.
-
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.…
-
Need help with "WEEKNUMBER" and "TODAY" formulas
Hi Community, I am having a hard time getting my "WEEKNUMBER" and "TODAY" formulas to work and I am hoping someone can point out what my mistake is. I have created a metrics sheet to count the number of action items due over then next 6 weeks. I'd like the sheet to show rolling weeks ahead. For example: Current Week,…
-
form and automation issue
J’ai créé un formulaire mais j’ai plusieurs problèmes : - Lorsque le formulaire est envoyé à un contact, il reçoit un e-mail qui n’a pas le même que celui que j’ai créé dans l’automatisation - toutes les lignes sont jaunes dans l’e-mail - la personne qui fabrique/complète le formulaire que son nom n’apparaît pas dans…
