-
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.
-
Is it possible to visualize Power BI data in SmartSheet?
Our company utilizes Power BI to track project dates and we'd like to be able to auto-update these specific dates into a SmartSheet sheet based on similar project numbers used in both systems. We want the dates imported from Power BI into SmartSheet, not SmartSheet info into Power BI. Is this possible? Thanks!
-
Automatic RYGB Lights
Hi All, Currently I'm trying to make my RYGB column give the right color light when it meets certain criteria. This must be based on a Start Date column, End Date column and a status column, but I can't seem to figure out a formula that works. So the way it should work is like below: Is there anyone who might know a…
