-
Help identifying duplicates using two columns but excluding entries.
I would like to locate duplicates in my sheet using the name column and email column. Just starting with the name column gets me nowhere. I keep getting #UNPARSEABLE. I am using =IF(COUNTIF(Client Name:Client Name, Client Name@row) > 1, 1) in a separate column. Eventually I would like to include the email column which has…
-
Turning on Resource Management triggered automation???
Help please! A teammate turned on Resource Management on a critical sheet for our day to day operations. This seems to have trigged automation that archived all rows. While I can see the rows that were archived, I am reluctant to move them back without knowing How to identify the automation that was triggered in the first…
-
Dashboard is a blank screen
I am trying to create a dashboard, and when I click "Create", I either get an error message or the dashboard is created but the screen is blank. Any thoughts on why this is occurring?
-
How do I print a 2 week calendar?
Hello, I am looking for a way I can print the calendar showing a 2 week view per page and not the full month. Has anyone had success?
-
Smartsheet continues not to load. Support login not available.
Every time I've tried to access my sheets and workapp, the service is slow and doesnt load. I've tried restarting, logging out and in and accessing the support site (which doesn't load....not sure why since I have a paid account as a former employee). Please help - I need access to this data asap for tax purposes.
-
How can I return a value in one column from another sheet based on two inconsistent string criteria?
Hi, any help with this will be hugely appreciated. On my master sheet I have a "Task Name" column, an "Audience" column and a "Description" column I want to populate with this formula. On the source sheet I have a "Task Name" column, an "Audience" column and the "Description" column I want the data from. Unfortunately, the…
-
Folders within a workspace should sync just like the workspace itself when creating a report.
I recently discovered that a folder within a workspace (which has the look and feel of a folder) does not function in the same way as the workspace itself. When creating a report I may want to focus on a subset of items in a folder and ensure that it syncs anything within that folder. In my case, my workspace contains…
-
does a system admin have the ability to see workspaces that have not been shared?
Our President had created a workspace and wanted assumed the System Admin had the ability to see all workspaces. Does the SA have the ability to see workspaces that have not been shared? If not, is it possible to share workspaces to SA by default?
-
Smartsheet login issue
I recently addet a user to my workspace and sent him an invite link, by accident i send a second one shortly after. He opened the website using the first older link (i dont know if that is relevant), now if he logs in he gets the taskbar on the left but the rest is just gray. If he try´s to open the workspace it seems like…
-
Sequential numbering not working (Project with WBS sheet)
Hi All, I am fairly new to Smartsheets, so please be kind :) I am creating a WBS with the Template the Smartsheets provides (Project with WBS sheet), but I am noticing that when I add new tasks between other already created tasks, the numbering goes all wrong. Also, Even if I add more tasks underneath, the numbering is not…