-
Do not add 10 blank rows at the bottom of the sheet
Please STOP adding blank rows to the bottom of the sheet. They are unnecessary and can cause issues with formulas.
-
How to get report to show up in sheets folder?
Hello all, I have a Smartsheet report that I can access from the home area or if I click the link directly. However, when I go to sheets, it is not showing up. In the second image, you can see there are no reports, only sheets. Is there a reason that the report is not showing up in the sheets folder? Does it take a few…
-
Freeze Row
Enhancement request to add capability to freeze row (like freeze column)
-
Data mapping for documentation
As we've been increasing our implementation across all of our departments, the need for documentation is growing. I think it would be nice to have a utility that would generate either a graphic map, or spreadsheet; that show all cross-sheet references, automations, cross-cell references, etc. This would help in creating…
-
Freezing top row OR colour the header row
Am I able to freeze row 1 on a sheet so when people fill out the form, the data imports underneath row one? OR Can I change the colours of the header row like I have with row 1?
-
Merged: Allow Certain Users to Make Edits to Specific Columns
This discussion has been merged.
-
Checkbox Formula Not Working in Metrics Sheet
I am trying to make a metrics sheet that shows how many checked boxes there are in my sheet. The tutorials I found said that "true" and "false" mean whether the box is checked or not. Why are my results showing as 0? I should have at least 20 as checked. I used the formula COUNTIF({checkbox 1}, [Column7]@row) This was…
-
Custom Colors for Sheets
While it is wonderful that we now have the ability for custom colors on Dashboards, it would be truly helpful to also have this same ability in Sheets. It would be really helpful for some of our projects because our district uses certain colors to call attention to various district initiatives or our district instructional…
-
You do not have access to this item
I was given access to Smartsheet this week but when I try to access a sheet in my workspace the message tells me that I do not have access to this item. My Admin has added me to the group for the workspace, as far as I know everyone else in the group has access.
-
Automate Weekly Copy/Paste of Hierarchy
I have a weekly tracking sheet that I update each week by doing the following: 1) Copy/Paste the current week's hierarchy (lines 546-561 in screenshot) to the last row of the sheet, 2) Update the week column, and 3) Clear some of the data for the new week. While this doesn't take a long time for one sheet, I do a similar…
