-
Customer Survey and NPS Scoring
I have set up of customer survey that includes an NPS question. I am not too familiar with reporting and dashboards yet, so I am having a difficult time envisioning where I should do my NPS calculations ie. Intake sheet, separate sheet, report, etc. This is also my first "solution" build. Currently, I am putting the…
-
WORKAPP VS. JUST A DASHBOARD
I have a Use Case where I'm deciding whether to use a just a Dashboard with Several Dynamic Views vs. setting it all up through a WorkApp. I have not used WorkApps yet, so am wanting to understand any advantages or features with using it. Use Case: Streamline our Single-Order process with a Key customer. [ They desired a…
-
COUNTIFS Function of # of Values Used in a Median Calculation for Metric Sheet
I have a formula in a metrics sheet where I am successfully calculating the median of values that meet a specific date range: =MEDIAN(COLLECT({Resi - Financial Approval Duration}, {Resi - Enter Stage 7 Date}, AND(@cell >= $[Start Date]$1, @cell <= $[End Date]$1))) I now want to calculate in a adjacent column the total…
-
Cell Contents deleted during edits
Hello Has anyone seen an issue where the contents of a cell are just wiped clean as you navigate from one cell to another by using the arrow keys or hitting enter? This appears to be a random effect and not browser based and appears to have started only recently. Did not do this before. Thanks
-
Days of the week symbol in column
It would be cool if there was a column type that was a "days of the week" where it's basically seven dots with S-S and based on the days of the week for that row, either selected in that column or based on a calculation, it would give you a symbol for the days of the week that the row corresponds with. It feels easier to…
-
Attachments sheet to dashboard.
Is it possible to do so that the attachments attached to the sheet would be automatically seen in the dashboard ?
-
same columns appear in multiple sheets
Hi I want to know how I copy some columns from master sheet to another slave sheets and, also slave sheet should follow the modification done to the master sheet simultaneously.
-
Check In/Out inventory log
Hello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveaways that come back after the event, and I need a way for this to reflect the number…
-
Using smartsheet logic step in forms - new row created in backend sheet?
Hi, I have created a logic step where if the form user fills out yes to a question, two extra rows appear. I have tested the form and it works but the additional information appears in the back-end sheet as extra columns. Is it possible for the info to be separated into two different rows rather? We would like the basic…
-
Sumifs w/ cross sheet references not working
Hello, I have a customer list and I am trying to use it to extract data from another sheet to get customer specific information. My SUMIFS formula to total the $$ for all projects with a specific customer is working. =SUMIFS({BidBoard Quoted Value}, {BidBoard Customers Bidding}, HAS(@cell, Customer@row)) But when try to…
