-
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…
-
Form Submissions aren't appearing on the sheet!
Hello! I created two sheets with separate forms and when I checked to see if anyone had submitted the forms yet, I didn't see anything on either sheet but when I click on "manage forms" it says that there are 62 submissions for one and 18 for the other. How can I fix this so I can see what people are submitting?! Thank…
-
Attaching Excel file to dashboard
Is there anyway to attach an excel file to a dashboard where when you click the link or image it will download a copy instead of opening a web version. I want people to be able to click on the link and have a copy download and open so they can input data and the save this excel file and then attach it to a row using forms.…