-
Additional Criteria changes result
Hi folks, I'm struggling with a formula that should be simple. When the formula is this, it works great for one of two Types. The second type pulls the wrong Billing Annual Fee. =IFERROR(INDEX(COLLECT({Billing Annual Fee}, {Segment}, Segment@row, {Billing Ownership}, [Billing Ownership]@row), 1), 0) When I modify the…
-
Legacy Dropdown Functionality Option
Good afternoon, Recently there was a change that made searching a dropdown by typing inside of it switch from an exact match method where typing S would only show entries that begin with S to a search within method where typing S would show all results with the letter S in them. I can see how this would be beneficial in…
-
Workspace
I have a workspace titled 2026 Activity. I need to create another one for 2027 Activity. All the sheets in the 2026 workspace will be moved to the 2027 workspace including the dashboard. All data must be retained in the 2026 workspace but deleted from the 2027 workspace. How can I make this happen?
-
Decimals added in drop down value from form
Hi, I have a column that can only be a drop down value. Unfortunately this value, project numbers, has a mix of both decimal and non-decimal values. For example, project 356 could be the main project, but has ancillary projects: 356.1, 356.2, ect. What I'm seeing is that in my project ID column Smartsheet has started…
-
Where can we find the sheets a column is supplying dynamic dropdown information to?
Hello everyone! I need to delete a column that is used in dynamic dropdowns in other sheets. How can I see a list of all the sheets that will be affected by the change? I'm looking for a way to find every sheet and column that uses the original column for their dropdowns. Thank you!
-
Import data directly into existing sheets in table view
February 16, 2026 We've all been there — you have a spreadsheet full of data sitting on your desktop, and you need it in Smartsheet. Until now, importing a file meant reverting back to grid view. Now you can stay right in table view and import your data without ever leaving the view you're working in. Now you can import…
-
How can I set up a Notification if my Primary Column is not a contact list, but the Requestors email?
Hi, Is there a way that I can set up a Notification Automation that goes to the email/requestor is their email is the Primary Column? Currently I have the Primary column as "Created By", and the requestors input their email address. But, if I try to set up a Notification automation using the Template or even from Scratch.…
-
Why the dropdown menu is not searching for the first characther anymore?
Since a few days ago, the smartsheet started working differently. I used to write in a cell with dropdown menu the number "5" for example, and would show me the option "5 - built" straight away as first option. Now if I do the same, the first option that appears is "0.5 - waiting", this is really annoying because after…
-
Display Attachment Names in a Column
Hi everyone, Is there a way to display the attachment name(s) in a column?
-
Automation to Only Include Attachments and Comments
Currently an Update Automation and a Request for Approval Automation cannot only include the Attachments and Comments. It must also include another column. It would be nice to have an automation that only includes Attachments and Comments. This would allow someone to review the attachments and provide comments when there…