-
Form Headings - Automated
When I create a Workflow the pop up format allows me to insert a Heading that then appears at the top of the Form when any communication is generated. I can use that box to include the name of the Project for example, the title of my SmartSheet - Project XXX, Phase YYY, Location ZZZ. When I use the email icon at the end of…
-
Importing and exporting multi-select columns
Hi, I've imported data from MS Forms via Excel. There are several columns which contain data from multi-select answers. What is the best way to import these? I've done some of it manually, but I'm finding it difficult to verify with the original as when I export to Excel all the multi-select entries are concatenated.…
-
Creating a Completion Per Agent Dashboard
I need to create a dashboard that shows how many emails each agent has completed. I have a main sheet that everyone enters in how many emails they completed. So in 1 column, Emails Completed, then in a 2nd column I have a dropdown contact list to choose your name from, then the time you started, ended, and the date.…
-
Alert when a "check out" event is missing
Hello Fellow SmartSheeters, we're using SS to track when individuals come and go from our laboratory. We're using this to identify individuals at risk of COVID exposure. For example, student A is working in laboratory in limited capacity. She develops COVID symptoms and tests positive. We would like to be able to rapidly…
-
Finding an average within a sheet summary
Have copied a sheet summary to each of my projects (350+) and I have created a sheet summary report pulling the data that I need. I am pulling the start and end date for a certain activity and the number of days between them... Now what I am trying to do is find and average # of days for the items that are on the…
-
Name that comes with auto-email workflow
Hello, I'm the owner of a sheet and created several workflow on it. All workflow email (reminder, update request etc.) come with my name while it should be the name of my colleague. I re-created the workflow with his name, but didn't work. I tried to make him the "owner" of the sheet but I have error message. Do you have…
-
Is there a possibility to have an interactive Dashboard?
I would like to create a Dashboard in which my users can select/filter a value (like region for example) and then the dashboard graphs change according to the value selected by the user. This will allow me to create one single interactive dashboard instead of one dashboard per region. Kind of like the slicer function in…
-
Total Attachment Size
Is there a way to tell the total size of all attachments on a sheet? I have 1647 attachments on my sheet and would like to know the total size. Thanks!
-
Suggesting improvements
😕 Where do we go to suggest improvements? A first step would be to put this in an easy to reach location like right there on the Community page.
-
Visualizing dependencies
Team, I know in Project/program management “Gantt Chart” is often thought as the best tool to show and manage dependencies, but was curious if there are any other methods that are more useful. Most of our projects are related to Digital and Business transformation. I have seen some examples of network diagram, dependency…