-
Donut Semi to display both % and number?
Hi, is there a way to show both % and number value on a donut chart? I know when you hover over it gives both but is there any way to display both without hovering? many thanks
-
Formula to surface specified data and date from project task
I am trying to to surface to latest EOT from the task to row 1 on EOT Stage, and respectively the corresponding End Date to EOT End Date row 1. We may state EOT 1 - 5 on the project sheet, but it will only take effect the date is filled in. Therefore, the latest EOT need not necessary be 5. But in the following example, I…
-
Update sheet summary field via a report
I am using row reports and sheet summary reports. When I create a row report , I can edit fields in the report and it updates back into the plan /sheet itself. This makes it easy for me to meet with a team member and review only their tasks across my plans and update % complete etc. Similarly, I'd like to be able to pull…
-
Function for Counting Children of Parent Rows
Hi - I have been wrestling with this function and need some help. Here is the data: In my sheet summary, I am trying to enter a function to count the children who answer yes. I have tried it a bunch of ways, and it will count if I only ask it to count children, or if I only ask it to count the yes answers, but I cannot get…
-
integrar con un doc
Hola cual es el proceso para relacionar una tabla con un documento, doc, pdf ... de salida tipo carta, factura, etc Que necesito para hacer esta relación con algunos campos de la tabla. Gracias
-
dynamic dashboards
hi, I am trying to make my dashboards dynamic ; I am using a form where a choice is made via a drop down menu, then the user submits the forms and via a formula in the background (in a sheet), the dashboards data are updated. This works well but requires about 20 seconds to update. Is there any other way to accomplish this…
-
Formula to display one date in a range with 3 criteria
Hello everyone, Can you please help me with a formula? I have three columns: 'Start date' , 'Dose', 'Site'. I would like to consider multiple criteria: 1) the start date is in the future 2) the value in the 'Dose' column is 'drug' and 3) the Site is '01'. Based on these criteria there should be a list of dates, but I would…
-
Accessibility / Compatibility with Screen Reader
As we deploy Smartsheet across our department, employees who use screen readers are experiencing compatibility issues. I read the article regarding iOS voiceover and the 2016 community discussion on this same topic. My support ticket suggested that I reach out to this community. Any other ways to make Smartsheet more…
-
Filter on dynamic view
I created a filter on my dynamic view. Everytime I open the view, the filter is desactivated and I have to active, how can we lock the filter ON please
-
Como puedo sumar datos que son generados por formula de IF ?
This discussion was created from comments split from: SUMIF Formula.