-
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…
-
Merged: Report access should not depend on source sheet
This discussion has been merged.
-
Can multiple contacts in one cell report hours worked for a single task?
A group I am supporting would like to have a multiple contact "Assigned to" column for each task. However, the issue is that they want each person in this cell to be able to report different hours for that task, so a single task needs to collect the hours worked by all people assigned to it. Is there a way to do this…
-
Creative ways to show a form to a user
Hi, Not sure if this is possible but I thought I'd ask in case anyone has a creative workaround. I have a scenario where I want to send certain columns from one sheet to another. I'm able to do this using a checkbox and Zapier that does the heavy lifting. However, I'd love for there to be a way to bring up a form when a…
-
Hidden as a column attribute
It would be great if we could have a 'Hidden' checkbox attribute added to the Column definition in Sheets (with Name, Column Type, etc.). In many cases when we have Sheets with multiple helper columns that we would rather be hidden, I find that it is a time-consuming task to re-select the same columns to hide again after…
-
Workflow - list historical values on cell(s) based on criteria
Automation option that will list the cell history in a similar format that is available with the cell view history.
