Sheets

Automation change cell value no longer being translated to a $$ value?
Hi, I've noticed this issue in two of my smartsheet processes. I have an automation set up as follows: "When rows are added are changed and [Column A] changes to [Any Value], change cell value in [Column B] to "60" " I then set column B to be $ currency format. Up until recently, "60" changed to "$60.00" without issue but…
Feature request: How to merge cells in Smartsheet
merge data into cells like excel does in a user friendly way similar to this article. https://www.projectwidgets.com/how-to-merge-cells-in-smartsheet/
Best way to visually separate different phases in a Smartsheet tracker?
Hi, I often build trackers for workstreams that move through a process or lifecycle. Where these involve distinct phases, I’d like a clearer way to visually separate each phase within the sheet. At the moment, I’m just using coloured columns/lines as section breaks, but it doesn’t feel particularly clean or optimised. Does…
Template form link and Roll Up sheets
Has anyone done this? Can you add a form link (status update form) to a roll up sheet automatically once the project is provisioned in Control Center. Essentially the end goal is that already created template form, I would like the link to auto populate the form link from the status update sheet after provisioning so users…
Add Centralized Date/Time or Changeable time zone on System generated columns
Please use UTC or a changeable time zone for columns which are system-generated. I have a sheet where I transform the "Created" column which is in UTC to a date in EST for readability. The discussion user however is in PST. That changes the "Created" column which in turn changes the transformed column. Normally, this would…
I did a "Save as New" on my sheet and the new sheet is missing all the Proofs. How do I get that back?
Hi All, I thought I was being smart and did a "Save as New" to my Smartsheet to preserve all the information on all my rows and create a "Completed Projects" sheet. Then I deleted the open project from the newly created "Completed Projects" and then deleted the Completed projects from our main sheet. I noticed this am that…
Report adding and removing sheets
I have a report that consists of 27 sheets. Shared sheets and report with 3 people. These 3 people do not have the ability to add or remove sheets in this report. Is that normal? I would like for them to remove sheets as they complete a project. Attaching an image - the selection option is grayed out for them.
Subtracting Months from a date, Error #Invalid Value
I have three columns. One with a date 7/1/2027 in date format. One with a number representing the number of months I wish to subtract from the date column. Third column is a date column with the following equation: =DATE(YEAR([Column4]@row) - INT((MONTH([Column4]@row) - VALUE(Factor1)) / 12), MOD(MONTH([Column4]@row) -…
Allow Gantt view to use Date columns with Column Formulas for Start/End
I'm kind of flabbergasted that this is not currently possible in a Sheet, and I'm struggling to explain to my users why. It is already possible to populate a Date column with a Column Formula and then convert it to a Cell Formula, and then use that column as the Start/End for Gantt view / Project Settings, so the issue is…
Request Snapshot not received. I am the sheet owner. Not on spam/junk.
I have requested for a snapshot, but I have not received the email yet. Any idea why and what do I need to do?

Sheets

Discussion List