-
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…
-
Using two different colors of font in a column cell
It would be super useful if there was a update where we can use two different colored fonts in a single column cell.
-
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
-
Guest User with Admin access can't edit the sheet
I submitted a ticket, but thought I would ask here. I am having an issue with sheets that I own (our org is on a Business plan). For the last two years, we have been using the sheets without an issue - our admin and many Editors (all shown as Guest since they are outside of our organization) were able to edit the sheets…
-
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…
-
Account Suspended - Need to recover sheets
Dear All, my account was suspended for a long period in which my sheets were deleted. I renewed my account and asked technical support if my sheets could be recovered. I received this message below, but I do not seem to get a reply back afterwards and still do not have my sheets recovered. Thanks for…
-
How can i access to my worksheets
I been trying to access to my worksheets but it shows up the next error Anyone know how to solve this?
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
Rolling budget/spend tracker
I have a bit of quandary with a recurring task, wherein I am tracking weekly budget allocations and tracking what is NOT spent. Currently, I have a basic sheet where my contractors/vendors upload a patient record, which is just a sign-in sheet, and I manually count the hours used. Each of these sheets represents a maximum…
-
Why aren't my dates not auto populating from predecessors?
-
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…
-
Common / Consistent Column (multiple sheets)
Is there a way to have the same "drop down list" across multiple sheets? We have multiple sheets, that use consistent/common columns (with drop downs) and for consistency I'd like to have the ability to make changes in 1 place and it flow through all of the sheets. Possible? 😊
-
I cannot seem to cross reference a sheet to another sheet and im going insane
Hello I know this might be very simple but I have tried everything to cross post a value from one sheet to another and I always get the wrong ref error or the unparseable one, this is the formula I'm trying to use, please help. =COUNTIFS({RE Projects Range1}, "Counter", {RE Projects Range2}, "Complete")
-
Can "Viewers" download/export sheets?
In the new USM, are users who are designated as Viewers only able to download/export sheets they are given access to e.g. to Excel?
-
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…
-
Help Needed
Hi All, I am trying to create a formula to work out the number of days ( Helper V1 ) between the VISIT 1 and VISIT 2 days column. Any thoughts would be greatly appreciated Thanks
-
What do you use for your Sheet Reference Name?
Do you use the standard {Sheet Name - Column Name} ? Or do use a simple name that can be easily identified? Or Do you use abbreviations? Im curious and would like to know your approach, Im hoping I could learn a lot from your experience.
-
Hyperlinks in Sheets/Reports Should Open in a Separate Tab/Window
Hyperlinks in Reports/Sheets should open in a separate tab rather than the current tab. My users would like hyperlinks in reports and on sheets to open in a separate tab or window. The way it is now makes it cumbersome to work off a report. There is not an option to right click and open in another window either.