-
Counting a cell with any data present
I have two questions here, any and all help would be greatly appreciated. A little background might be useful. Rows in my smartsheet are all considered one video item. A variety of things are tracked in these rows via the columns. 1. Using formulas (specifically COUNTIF OR COUNTIFS), can I count a row that has two columns…
-
Resource View
Is there any way in Smartsheet that I can change the resource view to be by month (currently it's by week)?
-
Deleting Cell History
Hi SS Users, So I have been busy setting up a whole lot of sheets, reports and sights - and been testing them extensively before we roll them out to users. As part of this testing, I have been typing in 'testing data comments - and some random made up stuff' into cells to test formulas, linkages, notifications etc etc.…
-
How do I change a user's login name
What is the correct process for changing a user's login name after they have a name change (marriage, incorrect spelling when created, etc) I see I can change the first name / last name, but I'm not able to find out how to change the login / email address.
-
How do I get an email notification when someone makes a comment?
Hi everyone I'm perplexed that the comment feature doesn't allow you to notify specific collaborators when commenting on a row. How does one know when a comment was made and specifically if directed @ them? Anyone have any suggestions how to make this work?
-
Cell Linking/Formulas in Reports
Has anyone worked on implementing cell linking from reports to worksheets and customizing reports? I dont see much in having reports if you cannot customize certain things after running, such as: formulas for totals in reports, conditional highlighting in reports, adding custom columns in reports. Also, without a cell…
-
Managing Tabs in Smartsheet
Hi, I have 2 queries regarding the tabs in Smartsheet 1. Pin tabs - Is there a way to "pin" tabs within Smartsheet in a similar way that you can pin tabs in a Chrome browser so that those tabs that you pin are always displayed and don't get moved to the "..." list? I have a core set of sheets/reports that I would always…
-
Lock a Sheet
Hi, Is there any functionality to lock a specific sheet. I dont think there is but this would really help for the situations explained below. There are two scenarios: Scenario 1 We have a master sheet, where all product information is pooled. there are 100 different columns and hundreds of rows. One team is responsible for…
-
Expand All after applying filter doesn't work
We have a sheet that has a primary column of parent categories with about 20 child tasks under each. The problem we are experiencing is when we filter by another column, the parent / primary column won't expand to show ALL of the child tasks. Below is an example of Program Name (primary column) expanded. I want to FILTER…
-
Card View - top enhancements suggestion
Hello, I find the Card View very helpful. In order to take it to the next level of usability, I would like to see the following enhancements: -Ability to edit fields straight from the Card View: checkboxes, dropdowns, etc -Full conditional formatting (more than just the task bar) -Card sorting (withing lanes/bugets) in…
