-
Scroll via trackpad not working after update
Anyone else have the issue where you try to scroll through a sheet with a trackpad but the sheet doesn't scroll? This has been going on for awhile and I notice it on all my devices (Surfaces) and on different browsers (specifically Edge) in Windows 10. Mouse wheel works. Happened after an update I think...
-
Could I refer a cell as part of the sheet name in functions?
I have a column with different carriers such as "AT&T" and "Verizon". And in the following column is a complicated nested functions, and part of it is doing search depending on the carrier name. For example, for the row "AT&T", I want search in the sheet named "ABC AT&T". For "Verizon", I want to search in the sheet named…
-
An Alerts and Actions rule has become invalid
Overnight I've received 20+ "An Alerts and Actions rule has become invalid" emails from smartsheet due to an employee who left our company several weeks back. Although his account was removed via LDAP, his email address exists in smartsheet alerts across our corporate smartsheet account. Is there a way to completely remove…
-
How to hide rows on a list?
Hello everyone, I am on the trial version, testing to see if it will work for my company. I loaded a spreadsheet from Google Sheet, and I am trying to hide some rows. I clicked everywhere and wasn't able to find. Would somebody please help me? Super thanks in advance!
-
Send Row to another sheet (not via email)
I have multiple sheets with similar columns, and I'd like to be able to send rows between sheets easily. I know I can just cut and paste, but is it possible to make a button or other similar automation that moves the row from one sheet to another? The Send Row function looks close, but I can only find documentation on how…
-
Limiting editable access to certain users
Hello there everyone interested! We're looking to share sheets to various departments here however we don't want all cells to be able to be filled in (or changed) by all users. Is there a way that we can restrict editable fields to certain user accounts so user A can only edit columns 1-3 and user B can only edit columns…
-
Common Picklist
Is there a way to define a picklist with values and then leverage that sinle picklist on more than one sheet?
-
Alerts not Sending to Assigned To Column
I want to send a daily reminder listing open tasks to contacts listed in my Assigned To column. All contacts have been shared to the sheet as Editor - cannot share. At least a couple of these contacts are users who have used SmartSheet before. I set a conditional formula in a reminder date field to populate with today's…
-
Either / Or but not both
Hi Could someone help please? I'd like to set a formula in a sheet with say 3 columns. It needs to sum/count depending on the answer of the first two columns but not them both. If either of the columms say "Yes" then that is good enough to be counted in the 3rd column. For example: Column A: Yes Column B: Yes Total: 1…
-
Agile - Reporting "dead" tasks
Hello, I am new to Smartsheet and agile and am looking for best practices. If you plan a task for the sprint and it suddenly is stopped or placed on hold, what is the proper way to record this? Should you simply delete the task from that week's sprint? Perhaps add a status called "Dead/On Hold"? When it's outside of your…