-
Formula - Counting and Blank Data
Hi. I need to know what is the best way to Count but exclude any cells that are blank. I am looking to count how many machines I have per my programs but I don't want to count the ones that have no date. I've read I should start with Is Blank but that didn't work. Thanks you in advance. Ali
-
Merged: Using two different colors of font in a column cell
This discussion has been merged.
-
Attachments for Non-Subscribers
I use Smartsheet for construction management (scheduling and quality control). I currently have an automation established to send a notification to a contact in a specified column when a row is added and assigned to them OR if a change is made to row that is assigned to them. Can I set-up my smartsheet to allow…
-
How to prevent reports and dashboards from breaking when renaming sheet columns?
Hello! I’ve noticed for a LONG time that when I change the name of a column in a source sheet, the corresponding column in reports breaks, which then causes dashboard widget charts (that rely on those reports) to fail. Is there a way to: Prevent this issue when renaming columns? Fix existing reports and dashboards without…
-
Averaging a number column from prior full weeks
I am having a hard time crafting a working formula. I have a Dashboard data sheet that I am pulling/calculating metrics into from other various Sheets. In one sheet, I have a date column {DID} and a Number Column {NOD}. I am trying to build a formula that will average the number column if the date column is in the last…
-
自動化設定でシートサマリの情報を使いたい
自動化で通知ルールを設定しようとしてます。そこで通知の宛先を、シートの列情報として保持している連絡先情報でなく、シートサマリの方で表している連絡先情報に対して設定できないでしょうか。。？
-
Moving sheet from one workspace to another
Hello, I have a general question. looking to move a SHEET from one workspace to another. That sheet has a FORM and Workflow Alerts set up. Will that disrupt my workflow and inactivate the form link? Just want to confirm what I need to do to ensure the SHEET and workflow alerts don't break. User is the same. Second question…
-
Gnatt Chart Publishable Link - Troubleshoot
We have a company dashboard and we link a publishable gnatt chart (editable by anyone) in an iframe for users to make changes. We all have licenses to Smartsheet but this helps them make changes to a company wide sheet without having to leave the company dashboard and go into Smartsheet. I am unable to get the gnatt chart…
-
File menu operations in new views, now generally available!
January 14, 2026 New views (table, board, and timeline) now support the File menu, which centralizes key sheet-level actions in a single, easy-to-access dropdown located beside the sheet name in the toolbar. With this menu, you can duplicate, export, and see the activity log, without needing to switch views or navigate…
-
Hyperlink for mailto: in Reports, Dashboards and Grids
I've seen this topic come up a few times now, but couldn't find an enhancement request submitted. It would be nice to have the ability to link email addresses in Reports, Dashboards and Grids. The dynamic contacts in Smartsheet is a nice feature turning email addresses to a standard First/Last Name, but could we add the…