Discussion List
Numbers only column
There should be an option to make a column numbers only. I've had trouble with sum functions, only to find that people have made 'non-numeric' entries in fields that are intended only for dollar amounts. When this happens, I have to go in and find all the non-numeric entries and delete them to get the sum function to work.…
linking data from multiple sheets to a master sheet
I have multiple Groups working on like projects with and almost all columns are identical. I want to bring that data together into 1 sheet that I can look at to make sure across the board all items are getting completed. I need the master sheet to get new rows and then update a specific column that is tracking the…
Negative Number Formatting in Parenthesis
As a Smartsheet user, I want a standard numbering format to display negative numbers in parenthesis with proper thousands/millions/etc. commas and currency symbols, in order to visually display negative numbers in more of an accounting style rather than the standard negative symbol. I've had multiple colleagues ask if…
Convert Column Syntax Error
Hi, I am trying to use the formula =TODAY() - [Date Submitted]1 to make a column for {AGE in days} since a form was submitted. I am not the best at formulas but really want to base some automations on days old for sales management and KPIs Like this It works for one row but when I try to convert to column formula like…
Ability to chat to "@groups"
I am unable to create groups possibly as i am not admin but once i have list of project stakeholders added the relevant workspace, i would like to be able to message certain groups of stakeholders within different sheets. At the moment, I have to @ each individual stakeholder rather than just creating a group for those…
Can 'Editors' own individual sheets in a Workspace?
Hi, Can you own individual sheets in a workspace if you only have the editor permission level? I am the owner of a workspace and am trying to give ownership of individual sheets to users with editor access but I keep getting the following error message: If I upgrade this user to an admin I am able to make them the owner of…
Automatically change status to Open/In Progress
Can someone assist me with creating a formula that will automatically change the status to open/in progress when a RAID item is added and save to the sheet?
Search/Find Column Titles
Finding one specific column out of hundreds can be a real challenge sometimes especially if you are not the one who built the sheet or if columns have been moved around. Being able to search for column titles using CTRL+F (or really any other way of searching within SS) would be a HUGE time saver.
Check In/Out inventory log
Hello, I am hoping someone has an idea for a solution to my problem. I have an inventory that keeps track of giveaways. I created a second sheet with a form to fill out how many of each giveaway I pack for each event. I count the giveaways that come back after the event, and I need a way for this to reflect the number…
Default Search Should be Current Sheet
Hi, I frequently search for accounts by account #. I have tons of sheets with this same data in it. It would be nice to search by the current sheet as a default and if you want to expand then you can. Be a huge time saver for my team.