-
Bank Statement Checklist and weekly notification of missing statements
Good morning, I am trying to build/find a Bank Statement Checklist that will notifiy me of all missing bank statements. For example, as of today, we should theoretically all bank statements from October 2018 and prior. I would like a monthly email sent out notifying me or somebody of all missing bank statements. I am…
-
Editing a Drop Down List
I am creating a Tasks List and am wanting to use a Drop Down list to indicate the Client the Task refers to. Our Client list is ever-changing. Am I able to add or delete clients from the Drop Down list without affecting the data in the other Client cells? I am hoping to keep the list alphabetical, so additions and…
-
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…