-
Filtering/selecting columns?
Any way to filter/select only specific columns to view? I know you can hide columns and maybe that's all, but in a sheet with 50 columns that is super cumbersome. Would be great to have an option to filter or otherwise select to narrow the column view.
-
Lock or pin from Editing and Deleting. Even by Admin
Hello, I'd like to pin or lock or freeze a column from being edited as that information is going to archiving and doesn't need to be edited for the next 10 years. But I don't want to delete it accidentally, or edit the column contents. It seems like the lock only prevents Editors from changing the content. How do I make it…
-
% Complete in a Filtered Schedule
Hello! I am new to smartsheet and am having an issue. We have a schedule where we have several different project type options. Depending on the project type, the project types that are not applicable to that project are filtered out and hidden. So there are several hidden tasks in each of our schedules. The problem I am…
-
Protecting Special column when importing
Hi, I've got a sheet in which I import from an Excel spreadsheet data on a daily base. In that sheet I have a column (RYG balls) with a formula to calculate overdue estimates. But every time that I import the new data, that column is crushed. I even added it at the far end beyond the imported data parameter. Is there a way…
-
Scanning a Barcode
Does anyone currently know if smartsheet is capable of capturing data from a bar code?
-
Column Tooltips
I am looking for a way to have tooltips on column headers in a sheet. The reason is say you have a large sheet that is being used for data collection. Some of the fields people may not understand exacly what you are looking for, so having a way to put in a tip or description would be great.
-
Smartsheet with series of dates representing milestones acheived
i have Smartsheet with series of dates representing milestones acheived. Users enter dates as when they have completed each milestone, How do i measure days between these dates and then put into a dash board /charts depicting what the average days between each point is at each milestone. eg Date of request1 - date of…
-
Cell Text in Form Title/Description
Is it possible to pull values from a sheet into a form? See screen shot for more information. Thank you
-
Approvals, Updates and Deleting Attachment in a Webform during Update
HI there. I am only a month old Smartsheet user and currently under the Business Plan. i am building the New Hire Request Form for our company and I came across with problem in the multiple approval as well as the things to do before a request will be approved. When the requestor filled up the request form, it will prompt…
-
COUNTIF Formula for when a cell contains a specific word/phrase?
I'm trying to create a formula that allows me to count the number of times the word "Postcard", for example, appears in a list in a column. I am referencing a column in another sheet to do so. However, nothing I've tried works. My instinct was to try =COUNTIF({2018 Open Enrollment Feedback Range 1}, "Postcard"). However,…
