-
Delete All Comments
We often reuse Smartsheets from one year to the next. It would be helpful if there was a method to delete all comments the same as you can delete all attachments. (If you can't do this with proofs, that would be a nice addition also.)
-
How do I get the exact number of Years based on the date column (no more rounding up)?
Hi there! Can anyone kindly please help me with this - I'm new to SmartSheets and having trouble working out formulas… In one column I have dates that Volunteers started volunteering with our company. The second column I used the following formula to get the number of years that it totals: =YEAR(TODAY()) - YEAR([Vol Start…
-
Updates to the Left Navigation, now generally available!
UPDATE: Thank you for your feedback on this feature. Our Product team will be rolling this feature back today, April 13, 2026. April 6, 2026 We've shipped two improvements to the Left Navigation to help you move faster and find what you need more easily. Search in Recents & Favorites: A new search bar in the Recents and…
-
Published calendar view not showing all tasks
When I publish the calendar view, not all my tasks are showing up. I have all filters off. In my regular view on the sheet, the tasks are there.
-
Interactive Graphics
Here is my goal: I need to create an image where the image has multiple areas. If one clicks on the that are (much like an image map in HTML). Then I need a secondary window to open where the use would select the status on that area. In Progress, not Started, Complete. But also I need it to show the last note added to that…
-
Automated Number Assignment / Sorting Formula
Hi - I'm looking for a formula that auto-assigns a number based on it's position in the sheet and can ideally be turned into a column formula. Our project format has the "Project Name" as the parent row and tasks underneath as child rows. I house multiple projects within one sheet, and i need to be able to sort by the…
-
Can you get a copy of the email responses that includes the details from the form, not just the headers.
I have created a form that ha a title and then descriptions. Is there anyway that you can get a copy of the responses which also includes the descriptions? Currently the response just includes the header but its the further details that I need.
-
How to return a blank when searching for max date and one of the dates is blank
I'm searching another sheet date column for the max date where two number columns (CID) are equal. It works fine, but if the list of dates contains a blank, I want the formula to return a blank instead of the max date it finds. =MAX(COLLECT({DAFD}, {CID}, @cell = [CID]@row))
-
Option to always display horizontal scroll bar
We need an option to always display the horizontal scroll bar. When working on a smaller screen, the scroll bar disappears. You have to scroll up and back down just to get it to appear. This makes working on larger sheets, which is always the case, very frustrating. This is reproduced using Chrome on Windows 11.
-
Next Outreach Due Formula Help
Hello, I’m looking for assistance with a Smartsheet formula I’m working on and could use a second set of eyes. What I’m trying to achieve: I’m currently working on an outreach program that needs to calculate the Next Outreach Date based on outreach activity. Our team makes up to three outreach attempts, and we also have an…