-
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…
-
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…
-
Merged: Please Remove Cross-Sheet Reference Limit
This discussion has been merged.
-
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…
-
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…
-
Keyboard shortcut indent after CTRL+K went away
Thought I would start my own thread regarding this since it seems very quiet around this change. Am I the only one having no luck in using the suggested shortcut CTRL ] to indent? I am using Windows 10, Chrome webbrowser and swedish keyboard ( ] = AltGr 9) Ctrl AltGr 9 just types the symbol ]. Anyone else struggling with…