-
Comments for Conditional Formatting
When creating conditional formatting, it would be helpful to have a Comments field where you could add context on what the formatting is indicating, and why it is doing it. This is helpful when you have multiple people that manage the conditional formatting. See the attached photo for a mock-up of this idea.
-
FolderResources.GetFolderChildren isn't returning the createdAt and modifiedAt for sheets
The new version of the api (FolderResources.GetFolderChildren) isn't returning correctly the createdAt and modifiedAt fields for sheets. As an examplle the following call isn't returing the fields correctly : SmartsheetClient.FolderResources.GetFolderChildren(9999, null, null, null, null, null, null); Can someone raise…
-
Quick Fill to Multiple Cells?
Is there an easy way to quickly drag down the same cell values to 1,000+ cells? Important: I have the sheet filtered, as I only want this to be copied to specific rows. I have over 1,300 rows on the sheet, so I can't just use the column formula functionality. I was hoping I could just double click the bottom right corner…
-
Merged: Line Banding
This discussion has been merged.
-
Save as New Issue
Hello, I'm encountering an issue when attempting to copy certain Smartsheet sheets. When I try to "Save As New," the process consistently times out, indicated by a spinning cogwheel. On occasion, I also receive an error message stating that Smartsheet is unavailable. This problem is not affecting all of my sheets, only a…
-
How to automate data involving dates and sum totals
I have been researching this topic for some time now and have been having trouble finding an answer - hoping the Smartsheet hivemind can help! OBJECTIVE: To obtain a sum total of data submitted via a Smartsheet form, based on submission date. CONTEXT: I work for a transportation company, and we use a Smartsheet form to…
-
Cannot open a sheet
I What can I do to recover my sheet? When trying to open a sheet, the following error messages appear: Thanks for your help! Ghislain
-
Ownership question
Hi everyone, I recently created a new workspace to centralize all my team’s information in one place. To move all existing sheets into this new workspace, I had to become the Owner of every item. Now I’d like to return ownership of specific sheets to the people who actually manage them. However, when I try to change the…
-
Automation template not working
I am trying to use the automation template in a work plan sheet, where when I change the project status column to "completed" the "% completed" changes to 100% on the row. I have even tried to reverse it, and say when % completed = 100% change project status to Completed. This seems like a very simple ask, and is a baked…
-
Dropdown Question
Is it possible for dropdowns to filter by value? For example, my dropdown options are: Solar Battery, Winter Battery, PV Panels, PV Interconnections. If I type into a cell that uses this dropdown and enter “Battery,” none of the battery options appear. But if I type “PV,” then both “PV Panels” and “PV Interconnections”…