-
Why doesn't INDEX(MATCH) work as intended?
Hi, all: I've recently been assigned to work on a set of tools for my team that have been run in Smartsheet for some time, and am really struggling. Setup: 4 sheets, for 4 separate project-cycle teams. Each sheet needs to refer to the same core set of unique IDs entered in the primary column for Sheet 1. All sheets contain…
-
Keyboard shortcut to delete the selected row(s)?
Has this feature been added? Reviving an old thread from 2015 posted by Maxim Miller (see below) and I'd like to see if there's been an update: "I can't find how to delete the selected row using keyboard. I can only do that using mouse. It's very inconvenient - in MS Project I select entire row using shift+space and press…
-
Why is Resource Management Synchronization showing up on my activity log?
Hi all, I just noticed that my activity log is showing that Resource Management is syncing with an API, but I never set it up to do so nor do I even have access to RM. I noticed this on my other sheets as well. Can someone tell me how this is happening? Thanks! Brad
-
Duplicate data formula which references two values
Hello Community, I am trying to find duplicate invoice numbers for the same client within two of my sheets. I need to show if there have been any duplicate invoices for clients using two criteria but am unsure how to create the formula. I want this information to show in a checkbox form. =IF(COUNTIF([Invoice #]:[Invoice…
-
Sheet output without Column names
How can I print a sheet without the column names printing? I would also like to be able to export to an excel spreadsheet without the column names appearing in the spreadsheet. How can I do this?
-
Create a Link to A Filtered Sheet
Does anyone know of a way to link to a filtered sheet? I want to create a number of links on a dashboard which when clicked on will show the same smart sheet but with a different filter applied. e.g. I could have a link that says "Red items" and another that says "Blue Items" the interaction on the link would be to open…
-
How to mark column with 1 or 0 if the month is in a date
Hi, I am trying to track whether or not someone has been active in a month based on their Last Login date. I created the formula to mark a cell as 1 if the month is in the Last Login date or 0 if it is not: =IF(MONTH([Last Login]@row), 1, 0) But the problem is it gives an #INVALID DATA TYPE error if it hits a blank date.…
-
Left Horizontal Scroll with Mouse
Any time I try to scroll left on a sheet, it takes me back to the previous page. So, if I am in a sheet and cannot see the left most columns, I have to select a random cell and hit the left arrow key until I can see the left columns. Right scroll works fine. I tried 'shift', it did not work. Any solutions or anyone else…
-
Numerical "Priority" Method
Hello, I am in need of a method for assigning priority of a submitted row 1-10. If 1 is selected, the previous 1 needs to become a 2, the 2 becomes a 3, etc. The column needs to recalculate when a row is complete and the 'priority' column becomes blank. I don't think this would be possible without using many columns to…
-
Copied Rows Randomly Placed in Blank Rows Below Target Sheet Content
Can someone at Smartsheet please tell me why copied rows are placed at the bottom of the target Sheet with multiple blank rows of separation? I would like to know the intent of the product team from the standpoint of user experience. Thank you.