-
CTRL + ] Does Not Indent, But Right Clicking Does
Our Senior VP is having an issue with a sheet where she is unable to indent a row to be a child/sub-task. The strange thing is she is able to right click and indent it, but not using the keyboard shortcut. The keys are working just fine (able to CTRL + C/V, and the [ and ] keys all work individually) but it does not allow…
-
Formula linking one column to another sheet; =IF(ISBLANK) function
Hi all! I need some assistance in creating a formula that links a column in my first sheet (Health Records) to a formula that is in another sheet. In this second sheet I hope to use the =IF(BLANK) function to display whether these records are "Complete" or if left blank in sheet one, "Incomplete". I have tried using the…
-
Add specific text to a row, if a condition is met in another column in the same row?
Hello, I would like to have Smart Sheet add the words "Bad Index" in the status column if index column is "647373". I can use conditional formatting to highlight the row, but when I try to use an automation trigger the whole column displays "Bad Index". This is my workflow. When I run the automation it marks the entire…
-
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?
-
Merged: Grouping in Reports
This discussion has been merged.
-
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…
-
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…
-
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…