-
Linking/adding rows using 2 spreadsheets
Hi all, I am having an issue that might be simple to solve, but I can't seem to find an efficient solution. I have 2 spreadsheets: - One with the ID, name, Lot and several other columns with product specification information - Another just with the same ID's, names and Lots, and a few bits more that don't pair with the…
-
Alterar o modo de visualização da planilha individualmente
Olá, foi o possível substituto do modo de exibição da planilha doce? a Planilha é compartilhada, mas todo usuário tem sua função e visualiza o conteúdo de forma, porém, cada mudança, por exemplo, no tamanho da barra, altera para todos os usuários, sendo que essa alteração é tão séria necessário para um único usuário.
-
Email based on cell value?
Is there a way to send an email containing the data from a row automatically based on the value in a cell? For example if they choose "Accounting" from a dropdown list or contact list in the "Department" column in row 1, then it would email the data from row 1 to the address on file for the Accounting Department.
-
Average Value Errors
Hello, Was hoping someone could see what i am doing wrong here; i am attempting to take the value of two cells and average them. Both are percentages. i use the formula =AVG([average calc]33, [average calc]34) and i get the "DIVIDE BY ZERO" error. From what i read this may be due to the particular column is a dropdown list…
-
Web Content Widgets
Is the Web Content Widgets available in the free version of Smartsheet? Which plan do I get this Widgets, Individual, Business, Enterprise ou Premium Options?
-
Update existing smartsheet by excel
Hi, I have a smartsheet with 4 columns： building code, name, cs manager name and supervisor. I create this smartsheet by import excel. Excel has 4 same columns.. However, cs manager always change. We have 1000 buildings. Admin will send update list every week.. I know there is data live connector.. if I change info in…
-
Give Specific User Editing Access to a Locked Column
I am looking to give a specific user access to editing a locked column. The background: We have a list of projects that are NOT to be started until our finance director approves said project. As the project manger, I am owner of these sheets. To prevent other users from approving projects of their own will, I have locked…
-
Best Practice - Data Integrity - Forms
When your business starts to build lots of sheets (as we have) the issue of data integrity comes into play. That is if you have lots sheets with names, or activities you can now put them into one sheet and reference to them BUT whenever you build a form and want to restrict the user selection to the defaults in the drop…
-
Will we ever be able to assign a task to multiple resources?
Is there any update on when this feature will be implemented? I cannot believe it is still not possible to assign a task to multiple resources. We are going to need to move to another site soon if this issue is not resolved. It seems crazy that after 12 years, this essential feature still does not exist, while something as…
-
Notifications and update requests
I'm automating the update request and reminder stages to update my activities. The worksheet is not shared, but I've enabled the alert permissions for the least restrictive. The actions and alerts indicator column appears in the reminder symbol and is in pending status, but is not sending email to the requested contact.…