-
Embedded IF(AND(OR Function Help
Hello, I have three columns in my sheet each with dropdowns including a "Complete" - type answer and a "Not Required". In the fourth column, I am trying to write a formula to show when the row is 'good to go' - such that all three columns read either "Complete" or "Not required". I've tried to do this by embedding an "OR"…
-
Need help in AverageIf formula with 2 condition
Hi team, I need help with an AverageIF formula. I am working on the request tracking system for Import shipment. I would like to calculate the average days in transit with 2 conditions, 1. Country (USA, UK, Sweden, etc), 2. Mode of transit (Air mode, Ocean Mode, Courier mode) + Average days in transit. Existing AverageIF…
-
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.…