-
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…
-
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?
-
Help on formula: count if with multiple criteria
Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, "planning", Stage:Stage, "strategy", Stage:Stage, "tender", Stage:Stage, "evaluation",…
-
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…
-
SUMPRODUCT Workarounds?
Hey all, I'm evaluating Smartsheets for my business and trying to determine whether workarounds exist for some necessary calculations. Three big ones are cost calculation, weight calculation and inventory management. I currently use Excel for these. My arrangement is I have all our products on the top row, with all of our…
-
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…
-
Data Mesh. How to pull multiple data points based on multiple selections into one cell
Hi Everyone, I'm looking into setting up a small process that would allow my team to essentially select multiple choices from a drop down in-order to combine the various results that those selections represent in a separate sheet. The key is that we want to combine those options in a single cell. Does anyone know if this…
-
Move rows Automatically | Automation Workflows
Hi, I have 1 source sheet and 1 target sheet. Using Data Mesh/ Shuttle, I'm adding the records to the target sheet from the source. There are chance that few records in the source can be deleted later and such records are not to be retained in the target as well. So, I added a column formula in the target that checks if…
-
Leading zeros dropped on Python SDK add_rows
We are using the smartsheet-python-sdk to insert rows into SmartSheets. For almost two years we have had this script running with no issue, but in the last week, SmartSheets has started to trim the leading zeros on fields that are all numeric. Nothing has changed in our sheet or in our script. Are others having this issue?…
-
The sheets of the workspaces I own are deleted by themselves every day
Good morning, greetings. Since I renewed the license, the sheets of the workspaces I own are deleted by themselves every day, please how can I solve this problem?