-
Using Multiple Sheets as Resource Allocation Tool. Allocations not updating based on date changes
Hello! I am trying to use sheets in a resource management type of way without the complexity. I have two sheets I am using. Sheet One: Holds all the resources. It includes allocations based on dates. Sheet Two: Displays summary of allocation. I would like sheet two to update the Total Percent Allocation for each person…
-
Can automated emails from a sheet be forced to individual emails?
Smartsheet is currently combining my automated emails from multiple lines into a single email. Is there a way to force each line to get its own email? I have column placeholders in the subject and body of the message, but it always combines lines into a single email when the automations are triggered at the same time for…
-
Export Column Properties
Is there a way to export the column properties of a sheet ? It would be incredibly beneficial to be able to export the structure: Column Name Column Type Allow multiple values per cell Restrict to list values only Values Restrict to dates only Allow multiples contacts per cell Restrict to list values only Add contacts…
-
Sheet automation notification email tracking using a PowerAutomate Flow and Outlook
This post details how to track all sheet automation notifications emails. This solution is medium complexity and will likely require you to use an AI for some simple coding. Smartsheet allows users to automatically send email notifications from sheets. There are a few significant problems with these automated emails.…
-
Can automated email come from a specific email address?
We created a tracker for the Records Management team and need all emails coming from the tracker to come from the email address associated with the team. Is there a way to have all emails come from this specific email? I see options for the owner or from general smartsheet but not an option to have it come from a different…
-
Smartsheet Setting
In Smartsheet, we can publish a sheet with an open link for anyone to edit. However, this same setting for publishing a report with an open link for anyone to edit is disabled at our enterprise level. Do you know if there is a reasoning for this feature to be disabled for reports but not sheets? Thank you in advance for…
-
System Admin: How to export a list of all Smartsheet assets across the account?
Hi everyone, I am trying to generate a report that lists all assets (Sheets, Dashboards, and Reports) created by users within the same Enterprise account. I have System Admin permissions, and so far I have tried the following: Navigated to Admin Center → User Roles and Reports → Generate reports Selected Sheet Access to…
-
Not showing the result after submitting entry to the form
Any one also experiencing issue in Smartsheet right now. Where in after submitting entry on a created form in Smartsheet, it did not show up on the sheet where it supposed to show up. However there was a confirmation email that entry was successfully submitted.
-
How do I keep parent child row structure when moving items to and from other sheets?
I am working on setting up recurring tasks for my teams timeline sheets. I have 2 sheets set up to help the recurring task functionality. My question though is around if it is possible to set something up so that when an item is marked as complete the parent and all child rows are moved and they maintain that structure?…
-
UPDATE - Health and Wellness Solution
Here is what I have built out so far for my Health and Wellness Solution. Please note some information has been redacted, including my Forms Dashboard which is where I go to log most of my entries, it is more for me to see, it's not as pretty as these are. I'm a dork and record many things just for the fun of it. I started…