-
Task not scheduling properly
I have a plan in a smartsheet which isn't scheduling as expected. several task that have no predecessor seem to be staying put. I'd expect them to move to the project start date. I can find no option to change constraint type. I've exported it to MS Project and it exhibits the same behaviour until I review the Resource…
-
Adding a space between 2 vlookup functions
Hi All, How can you add a space between 2 vlookup functions? Here's the formula: =VLOOKUP(Alias247, {Pilot Data Base Range 4}, 3, false) + VLOOKUP(Alias247, {Pilot Data Base Range 4}, 2, false) This will show First_NameLast_Name. Thanks!
-
Report not updating when adding new sheet
I have a report tracking all new sheets when added to the folder in my workspace. The report does not recognize this new sheet and I have to manually go into every report (many) to add it to the sheet list. Is this an error in the workspace interface or am I missing a checkbox somewhere?
-
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?
