-
How to lock column in report
How to lock column in report
-
Filter on Contact not working
Hi We've recently had reports that the filter on a Contact column is not longer working. If you select 'Is Equal To' and then select the contact from the dropdown, the smartsheet used to filter on that selection. Now it returns 0 rows. The workaround, which is far from ideal, is to use the 'Contains' option. We've also…
-
Can't access any sheets when they're shared with me
Hi, whenever my boss tries to add me as a viewer to sheets we use to keep track of clients I never receive an email telling me the sheet was shared to me, and the sheet never shows up in my "shared to me" tab. I can't figure out why this is happening. On her end, it says that she shared it with me and i'm listed as a…
-
Groups dropping from Alerts
Hi everyone, Has anyone had issues with Smartsheet groups dropping off alerts that have been setup? I've had this happen 3 times now and I have to keep adding them back. Thanks for any advice.
-
Count Unique SME names
Hi. I have two columns SME #1 (Name) and SME #2 (Name) with names of subject-matter experts from rows 5 to 155. In many cases, one SME is assigned to more than one course (one course=1 row). I'd like to count the number of unique names in both columns. SME #1 (Name) | SME #2 (Name) Course 1 | Donald Duck | Course 2 |…
-
*** Times of execution of a requirements with different people assigned*****
Hi everybody, I need your help. Currently, our requirements request process is as follows, enter the form within Smartsheet register the emails of the people who want the application to send, Then these people receive and assign other resources if necessary. It is important to indicate that it is a single requirement that…
-
Linked Cells that are not read-only
We keep our master calendar/schedule in Smartsheet. Every year, we create a new copy of the sheet and insert dates for the new year, but the majority of the other content stays the same. Is there a way to do a cell linkage where the linked cell in the destination sheet IS editable? For example, for each row on the…
-
Dashboard Chart Formatting
I currently have a chart on a dashboard displaying information from a certain range of data. If I change what data is being selected, it reverts to default formatting (e.g if I select different data for a stacked bar chart, it reverts to a non-stacked column chart and all the colors per series return to default colors as…
-
Security on Column Level and per User
Hi, Could we have a validation or anything that prevents some columns to be updated by a specific user? Not all sheet, just some columns. Thank you.
