-
Rolling updates - can I automate data selection for dashboard?
I have a set of dashboards used to show the same data every reporting period. Reporting periods are 100 days long. They are identified as Start Month - End Month (x00 days). Is there a way I can automate data selection for my dashboards so that it picks the current reporting period ? Data feeding into the dashboard comes…
-
Export to PDF Selected Rows
Hey all, Hoping this is an easy fix. I can't seem to print/export selected rows, only the entire sheet. I'm trying to document employees scorecards in one sheet for supervisors then have them export the individual employees row to review with them on a monthly basis but it won't let me do the selected rows button. Any…
-
Restore previous version
Hi all - a poorly structured data shuttle update has deleted all my sheet data. I'm on hold to support but does anyone know how to restore a previous version of a sheet?
-
Override an Auto Number in One Cell
Is there a way to override an auto number in one cell, but leave the column as an auto number? Thanks,
-
IF level@row = X, Display short version of dashboard link, else calculation
Hello Community, I have a series of columns that are summarising the output of complex projects. I would like to be able to have a "Link to Dashboard" at the top of a column that is a column formula. The link would provide the end user with instant access to more detail if required. Ideally if anyone has a solution, the…
-
How can I get the subtask to populate a report that shows all the task assigned to a certain individ
I see that the task itself (Semiconductor certificates campaign) is populating the report, but how can I get the subtask to populate the report as well?
-
leading with "0" but the cell must be a number
I am trying to formulate a row so that it always contains three numbers, starting with 0. This column has to be a number and not a text as I need to sum the total in a report. Currently, I am only able to make sure there are three digits by making it a "text" cell but when I go to summarize the total in a report its not…
-
Grouping and summarizing in reports
Is there a way to have two separate groups in reports? Not one "then" another, but two separate ones. I have columns with checkboxes, and I want to group them separately so we can see which rows have "Answered?" checked and which have "Follow-up?" checked, but we don't want it to group in this way because we will have some…
-
Formula to Pull Just Words or $ Amounts into a Report
Not sure if this is possible - If there is a cell that has words and then a dollar amount, is there a formula that can be used to pull only the dollar amount into a report and then on the opposite side be able to pull the first part and not the $ amount? Ex: 11111 - Test Item - $100 The format for the example could…
-
How can I automate a Dropdown list, so every value added to the column becomes an option?
Hello community, I'm new to Smartsheet and I'm struggling to find out how I can make every value added to my column to become automatically a option in the form dropdown list. Anyone knows how I can do that? Thanks
