-
Anyone else have this issue with forms and know how to resolve?
I am having a problem with forms submitting into a SmartSheet. I've built a simple SmartSheet with some IF commands that apply a score based on dropdown menu answers. I also created a report that shows a selection of columns based on a field being populated. When I submit a form built from the simple Smartsheet, nothing…
-
link between sheets
Hi! I'm working with two different sheets. The first one has all marketing activities (webinars, events, trade show, etc). The second one has all the marketing assets created (Ebook, social media cards, etc). I would like to link which assets can be used for which marketing activities. A marketing activity can use more…
-
Link Reference Sheet Dropdown
Is it possible to reference a list on a separate sheet for the user to select as they input data into rows?For example; activity type, client name? I have created a time sheet and would like users to reference the data in another sheet. Thank you, Rachel
-
Is there a way to turn off email confirmations/receipts after the approval?
Hi- While using the automated approval process, users are getting additional e-mail after they approve the request. Is there a way to disable that? It just creates unnecessary e-mails and notifications serves to very little to no purpose. Which sort of contradicts with the purpose of the Smartsheet. Regards, Enes Z
-
Merge 2 column names from separate sheets into one in a single report
Hi I want to create a single report that can be circulated on an email that pulls data from 2 separate sheets. In some cases I've been able to align the column headings, for example "Assigned To" is common across both sheets. However, in renaming that column, the resulting report no longer has an option to "Group" based on…
-
How can I update two sheets with the same information?
Hi, I have a sheet I use to update my teams webinar calendar. Another team in the business would also like to know when a webinar relevant to their team has been added to this sheet, so it replicates on their own training calendar. Is this possible? I was added as Admin to their calendar. I tried setting up an automation…
-
How can I change non-working days for all sheets in my account
It seems pointless to set non-working days as a default within the Admin Console and/or sheet since changes don't seem to apply to any sheets unless they are brand new. None of my existing project sheets reflect changes - templates seem to inherit whatever was in the settings at the time the template was created. Please…
-
Pull Data from Another Sheet based on Criteria
Hello, Below is my master file of projects. I've filtered to show all the values based on "Automation" in the Drop Down column. Each project is designated with a project #. I want this sheet to function as a way to automatically carry over all the project #s from the master file to my new file (see below) based on all the…
-
Automatically disconnect sheets from Resource Management when deleted
Could you develop a fix that makes sheets automatically disconnect from Resource Management when they’re deleted—either initially or when they are permanently deleted after 30-days. It’s quite annoying to hunt down a deleted sheet—because you have to know the owner—and when it’s permanently deleted, you see that there’s no…
-
What is the "Last Modified Date/Time" column referencing in the Sheet Access Report?
From what I can tell, it's not reporting the last date the sheet was opened or edited, because I have a sheet that is used daily that's reported as last modified 7 years ago. Is this referencing the last time the sheet's structure was modified? If so, it's not very useful for helping identify underutilized or unused…