-
Certain Roles allow for unhiding columns
Right now, only the Admin role for a sheet can hide and unhide a column, but this causes issues for the rest of my team who are Editors. I would like at least one of the Editor roles to be able to unhide columns as needed. We don't want to make everyone an admin (for obvious reasons), but our managers will often hide…
-
Hidden Columns List
I would love to have a collapsable/expandable list of all hidden columns on a sheet with the option to unhide them from the list. This way, if I have multiple hidden columns and I just want one or two of them, I don't have to unhide everything to get to them. This would also allow you to look for columns that might be…
-
Update column based on last comment
Hi Team, How I can update a column (Status) based on who sends a comment within Smartsheet? In my case if the admin sends a comment to the submitter, the Status column updates to read "Need more information". When the submitter replies to the admin, the column will read "Info returned to Admin". Is there a feasible way to…
-
Merged: We need an activity log for automations (especially emails sent)
This discussion has been merged.
-
"Last Update" to look for last manual update, not last formula update
I currently have a column that counts how many days until the due date. Because this column formula utilizes "TODAY()", this means the column re-calculates every single day. Because of this, my "Last Updated" auto-fill column always lists today (or the last day I opened the sheet) as the time the rows were last updated. Is…
-
Merge & Center
Hello, The "merge & center" is a formatting option I am quite fond of inside excel and curious if I can replicate this in SmartSheet. I would welcome any feedback. Sincerely, Scott
-
Count the number of entries in the last 7 days
Hello I have a few questions I want to know if there's a way to count the number of entries made for the last 7 days. For example, I have a sheet with hundreds of entries which collects customer requests. I would a way to quickly display the number of entries for the last 7 days. Count the number of entries made weekly,…
-
Calculate duration between two times
Im looking for a formula to calculate difference between two times eg 08:00 - 10:00 should give a duration of 2 but running into errors. I have column types as text number. 08:00 is named Start Time and column for 10:00 is finish time
-
Why does the date default to 2025
I'm working on a Smartsheet for items that are in 2026 and I have some columns that are set to the date field formatted like 15-May-26. The issue is that when I enter the date like 15 May, normally I can hit enter and it would enter the year, but for some reason, it is still set on defaulting to 2025 as the year. Of course…
-
Introducing the newest Community Champions! 🏆 [January 2025]
If you attended one of our Jumpstart 2025 with Community parties last week, you've already heard: We have new Community Champions joining the program! I'm so excited to introduce you to them, as each one has been not only a star in the Community, but they also bring their unique perspectives and skills to the group. Please…