-
Smartsheet - Down to the Basics Cheat Sheet
https://us.v-cdn.net/6031209/uploads/7QUQBGF1SDX1/smartsheet-down-to-the-basics.pdf Hello fellow community members! When I first started using Smartsheet, I struggled—a lot. Even the most basic tasks felt overwhelming. As someone who learns best independently, I started creating a personal cheat sheet to keep track of all…
-
No "reference another sheet" prompt
Hi All, I'm a noob, trying to do a basic vlookup (or match, don't care), but when I start the formula, there is no "Reference another sheet" prompt, as I see in every single help video. I've tried directly typing in the name of the sheet/table, but it's not producing. =VLOOKUP([Contract Name]@row ,{List of…
-
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?
-
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…
-
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…