I have several dozen project sheets that I aggregate in multiple reports. Each time a new project is added to our portfolio, I need to remember to update each individual report to include the new project sheet. If I could create a single report that aggregates and then build individual reports from that it would be easier…
I'm working on a project where we will be pulling hundreds of rows of information out of a bunch (hundreds) of Excel files, and storing that info from each Excel file into it's own SmartSheet. I already have the process down to pull the info we need from the Excel and stores it into a CSV file, so then the CSV file can be…
Hello I saw a thread about this, but wanted to put forward my own situation as it seems a bit different. I am looking to automate some of our employee offboarding. I currently have a source sheet of employee data (Employee Database) which has a lot of sensitive data. I have set up a "helper" sheet which uses INDEX/MATCH to…
Today I saw that my pinned recently opened sheets and reports were now a jumble. I sorted them back out and as soon as I clicked one to open it zipped to the top. This change is not really welcome and I would love the option to change if these are sorted at all. Having an active list like I used to made many things much…
Is there a way to lock down a column so that a certain individual who has editing access can only edit one column? Regards... again, KB
Hi Team I have two Smartsheets Sheet A and Sheet B, Sheet A is the source sheet from which unique values in sheet B to be extracted. Can anyone suggest me how to achieve this? As shown in the screenshot Submitter Name is the column which stores duplicate names and need to be extracted in other sheet uniquely. Also the data…
Hi all, I have uploaded a pdf to be filled with some vertical texts. I have been careful to double check that the original pdf has been done correctly with the relative vertical texts correctly displayed. Now, when I upload the pdf in smartsheet to generate a form, the system returns me a pdf with none of the vertical…
Hi, I don't want my collaborators to open the source report from a Report Widget in my dashboards. How can I remove that link at the bottom of the Widget? I should mention that these dashboards are part of a Program Workspace. I can't remove the rights to the report without moving the report out of the workspace.
Hi all, I am wanting to make a format for a date overdue. If 5 days past the (Date ) Line to turn red Any help would be appreciated
I have a master file where it is multiple rows, what I need is make each row as individual smartsheet and whenever I update the Row in a master file the changes should also reflect in the respective individual smartsheet. Please assist me.
How would one go about getting access to a sheet/form if the person that created it is no longer employed?
Hi there, I am hoping to find a way for our staff who submit information through form to receive an email confirmation without having to get a copy of the information they fill in the form. At the moment the only email option is to have them get a copy of their response to the form, but I don't want them to have a copy of…
How can I customise an update request in a workflow, so that the updater has fields that are required to be updated before submitted the update?
Help shape the future of Smartsheet. Share your ideas and feature requests.