-
Add Stacked Area Chart type to Dashboards
Please add the Stacked Area chart type to Dashboards (available in Excel)
-
If Formula to return highest priority
My spreadsheet has 4 columns are updated each Month with Stable, Improving, Developing, and Negative. Negative is the highest priortiy, then Developing, then Improving. Please assist with a IF statement, that would look at all 4 columns an update the cell with the highest priority word.example 3 stables and a developing…
-
ODBC Smart Sheet Connector für Excel 64Bit ist extrem langsam ?
Ich lese Daten aus 25 Smartsheets ins Excel ein. Die Daten werden in 5 Listen zusammengefasst. Imm Anschluss mit Power Pivot in einem Datenmodell verarbeitet. Es geht um eine Anzahl von in Summe 30.000 Datensätzen. Der Aktualisierungsvorgang, bis Excel die Daten Erhält dauert eine Stunde. Kann man den ODBC Konnector…
-
What is the best practice to manage adding features and changes to Smartsheet?
We are working on adding testing and change management to our Smartsheet instance. What are best practices for managing changes, and having a Dev to Test to Prod style workflow? How are others managing test data and automations that are not in production yet? We are working to add additional functions to our projects,…
-
Is there a way to show a report of duplicate names across multiple sheets?
Hi all, I have about 6 sheets that act as master rosters for 6 different programs. I would like to have a report that shows which individuals show up across those multiple programs. Is there a way to filter a report to only show those individuals or is there another way of doing it that might be better?
-
Move attachments between sheets
Is there any way to move attachments between sheets without the clunky "Move a Row" or "Copy a Row" automation?
-
Flag first occurrence as “Unique” and others as “Duplicate” by person + date
Hi Community, I’m working in a sheet with a bunch of historical data that has these key columns: [Personnel Name] (staff contacts) Date (date) [Duplicate Check] (text, where I want the formula to live) What I’d like to do is: Treat each combination of [Personnel Name] + Date as a group. For each person+date group, mark…
-
Reports: Add Filter Option for "Current Month"
I want the following filter on Reports to have an option that is "equal to current month"
-
入出金履歴管理の設計について
個人単位の入出金管理について、設計の相談です。 Aさん〜Gさんなど複数名の入出金を管理しており、
以下のような構成を考えています。 ・シート①：全員分の入出金履歴（1行＝1取引） https://app.smartsheet.com/b/publish?EQBCT=63bab2005ccb46e5922aac9efd9bf560 ・シート②：名簿（個人マスタ） → 名簿側で現在の残高（SUM）を確認できるようにしています。 ・レポート①：個別の入出金履歴 https://app.smartsheet.com/b/publish?EQBCT=f090df15bdae4df894da7fc4ae26dfa2…
-
Inputting Contacts into Smartsheets
Hi Smartsheet community, question..my Smartsheet account is not allowing me to input contacts of contractors for project into my inspection reports. I have the correct information for each contact (ie. email and phone number). Would this be a restriction out in place on my company’s end or..I need answers. Any feedback…
-
Anyone Else See Stuttering Report Menues?
I have a weird, recurring issue with the column select menu on reports & I want to see if it's something others have experienced. I've found that If I try to scroll down on the column select menu for a report [new or existing] using the scroll wheel on my mouse, it keeps skipping back up. I can usually make it down a dozen…
-
I need to pull certain data from a sheet to another with specific criteria such as (completion 0%)
I am trying to write a formula that allow me to pull certain data from another sheet with completion % 0 and with specific type/name. I need help with the formula
-
Smartsheet Seat Type report Issues
Has anyone had issues with the Smartsheet Seat Type report? We have inconsistent data with the reports and admin center. One of our Smartsheet admins only shows making 6 edits within the last 90 days, but has over a hundred thousand edits for previous periods. The last paid activity date from the report shows 11-14-25, but…
-
Allow simple formulas to be add to cells in Reports
I can enter a simple formula in a text cell in a sheet but not the same cell in a report. I have a "Shipping Report" that our shipper uses when the ship out an order. It pulls the client's name, address, due date, tracking number, and shipping cost cells for a sheet. The shipping person can enter the tracking number, and…
-
"Sheet Name" column for Sheet
I have a report that pulls data from multiple sheets. Sometimes I want to know what sheet the data came from. The Sheet Name column on the report provides the name of the sheet from which the data was drawn. However, due to the formatting of the Sheet Name column, it's not easy to spot when data comes from certain sheets…
-
Solution to analyze multiselect dropdown data and visualize in a reporting dashboard
Hello! I'm somewhat new to creating reporting dashboards in Smartsheet and I'm running into issues since one of the key metrics my sheet has is a multiselect dropdown. I'm aware that you cannot group by a column that has a multiselect dropdown, but what would be a workaround for that so I can visualize that data in a…
-
Kanban or something else?
Hi all. I'm teaching myself how to use SmartSheet in way that works for me. I have a weekly check in with my boss and her boss. Right now I'm just using a grid but I really want to try to use a Kanban. What I cant figure out, and maybe I'm overthinking it, is how can i have it so that they can see the progress I have made…
-
Dashboard Labling "Series"
Im trying to get the series labeled so that the colors are Associated with a title such as buildings as seen is second picture re.
-
Exporting Workspace Shared To and Permission Settings
Hello!! Currently doing a review of who all has access to my workspace in Smartsheets. Is there a quick an easy export or something to see who all has access, their permission, and License type within a given workspace? Part of this exercise is determining who all is in my workspace and if they need Edit/Viewer access to…
-
Creating data to populate a dashboard
Hi all, I want to display a count of a particular item from 1 column (dropdown with multiple options) but need it to also cross reference another column (dropdown with multiple options). So example is if first column (Site) is "Preston" and second column (Contact) is "Warehouse" then give me a count of this combination.…