-
Allow access to specific items only
Hi all, I am creating a set of sheets. * Main sheet: gathers all the tickets about issues raised from the field (customer). Ticket (row) will be added using a customized form. tickets are coming from several types of users.* Engineers that belongs to the company. * Engineers that are external and belongs to the customers.…
-
Comments In A Report
I am managing several sheets, and want to create a report for myself and the team that logs or captures all the comments that are associated with the sheet/tasks. I am struggling to find a proper way to include the comments (visibly in a report) Thanks for suggestions.
-
Hiding who is viewing a sheet
Hello! So I have been using Smartsheets for a short while and I think it's fantastic! I do have a query though - Is there a way of hiding who is viewing a sheet? We have a sheet with a massive amount of data on there which is shared with numerous suppliers we work with. They all require the data for different uses, some…
-
Stumped with a simple formula - countif with sheet reference
I feel silly, but I'm stumped. I'm trying to do a countif with a sheet reference. I want to count how many rows in my Lease Tracker 2018 sheet have Agricultural in the Category column, but I keep getting #UNPARSEABLE. What am I doing wrong? =COUNTIF({Lease Tracker 2018 Category}:{Lease Tracker 2018…
-
Export smart sheet
Hi, I wish to export existing sheet data by last year month wise, i. e. i am using smart sheet since 2017 to till date, i am using smart sheet to maintain data and with getting updated by team, i wish to be have a data month wise which i haven't saved it on my PC and now i wish to see month wise data. please guide me how i…
-
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.