-
Email User Completed Form
I have created a form to capture some series of data. One of the fields on the form is for the user that is completing the form to key in their email address. I would like to create workflow automation when a certain trigger has taken place (example a checkbox checked) for the alert to be triggered and email a confirmation…
-
Copying Workspaces with Dashboards
We have a workspace with several sheets and dashboards. We want to copy this workspace for each incident we activate for. Is there a way to have the links within each dashboard automatically update to the workspace/sheet location? Currently we have to go into each dashboard and update the links - very tedious. We are using…
-
Published User issue
The Activity Log properly logs the system users and their activities. What shows is the user's name and the activity info. I notice however, that several entries in the log lists "Publised User" as the person whose acivity is tracked. How do I tell who this "published user" is, and why isn't the user's nme listed instead?
-
Counting criteria from a multiple drop-down column across multiple sheets
Hello, I'd like to show the number of tasks each person on my team is working on in a roll-up sheet. On all my project sheets, the 'Assigned To' column allows multiple names. When I attempt to aggregate the number of times a name appears in this column on all the referenced sheets, I get an incorrect number (no formula…
-
Row edit feature and sheets
Is there anyone that would be willing to work with me on the phone to work through this issue: I've created a sheet that has over 40 columns - it's my "master" sheet that feeds a bunch of reports that will be utilized by different areas. One of the areas prefers to work in the edit form to see the information vertically…
-
Sheet exceeded the maximum recommended size
Has anyone received this error message before? What are the options for large data?
-
Is There Really No Built-in Log\NL Function?
My team and I are trying to implement our escalation algorithm in smart sheet but it would seem that SS can't compute natural log in formula. Are we missing something; Why is the SS math library so dumbed down? Below is the formula in Excel we are trying to migrate. =ROUNDUP(LN(A2)/1.609437912,0)+1 WHERE: A2 is a user…
-
Status Report based on certain conditions, i.e. dates, status etc
Hi Smartsheet community, I'm trying to come up with a status report to display information on what has been done in our projects between certain dates. I would really appreciate your expertise and help!!! For example: Project A Status Report for the period 04/Nov/19 - 17/Nov/19 What I want to show is: 1. Completed…
-
Report shows dates from sheet summary but not text
I have created a sheet summary and copied same format to other sheets. A number of fields in the sheet summary contain linked data from the actual sheet using cell linking. This includes dates and text. When I created a Report (summary sheet) to draw from the three sheets, the dates show up in the report in the respective…
-
Sheet automation with a mix of relative dates and date ranges
Hello, One of our teams is using Smartsheet for team calendars, tracking things like time off, travel, working from home days, etc. Key notification criteria is based on start and/or end dates. Currently, their notification is setup to trigger when the start date is today. This doesn't catch when there is a date range…