-
Recording Week Tasks Were Completed
Hi all! I'm back with an old problem that rattled me a few months ago. Basically, when a task is completed, its date of completion is saved. For the sake of being able to a process this data in a more comprehensive manner, we want to take that date, and assign it a "weekOfCompletion". Another note, is that the weeks here…
-
Sheet Row Limit - Automation Recos / Suggestions
With one of our clients, we are running into the 20,000 sheet row limit, and I was wondering what others have done to work around this issue? My first instinct is to createduplicate a sheets, and then use a report to pull it altogether in the end. It's a pretty manual solution, so I'm looking for something more automated…
-
How do I email a central database of contacts?
Hi Everyone, I have two separate sheets. Sheet 1 is a database of all my different suppliers, which has their name, email, and specific item which they supply. Sheet 2 is where I specify what item I would like to procure at a certain time. Once I specify the item I want to procure in sheet 2, How do I automate an email to…
-
Duplicate Automation Email
Hi all. I am trying to notify a coworker when a customer has multiple entries on our sheet. I currently have it set up so they are notified, but it only includes the new line that was added showing it was flagged as a duplicate. Is there a way to have the email show both rows in the email notification?
-
Upload Data Shuttle Flow Deleting Rows in Target sheet
Hello Smartsheet group, I am facing the same issue trying to test an upload workflow. I have created an upload workflow that will pull from OneDrive - XLSX file and replace the rows of information into my target Smartsheet file. For some reason the target Smartsheet file is only deleting the rows of data and not uploading…
-
How can I flow cells from one sheet into multiple sheets based on date?
I am familiar with the copy cell automation to a different sheet. However, I am having trouble figuring out how to do this with one sheet>middle man sheet> to end sheet. The sheet in the beginning will constantly have additions with new dates and I want them to flow into a new middle man sheet (that will be created from a…
-
Change the "from" name/email address on automated emails
Hello, I know this is a repeated question. As an alternative to transferring the sheet ownership. How can someone create a service account? - I assume I have to ask the company to create an email address first and then transfer the ownership to the new service account as a free Smartsheet user. Any risk in doing that?…
-
Is it possible to create an "If" statement that includes a hyperlink?
I have a column of data which reflects the status of a project. Statuses include "Completed", "On Next Report" etc. I'd like to embed the report schedule into the cell when the project status is "On Next Report" so viewers can easily click and see when the next report will be published. In my head, this is something like…
-
Quick Link or Chart for Capacity Limits
I am frequently having to refresh my memory of capcity limits for cells in a sheet, workflows per sheet, etc. It would a great tool to have a quick link to a chart in Help or Community that is quicker to find or easily searchable within Help. Thanks!
-
Broken Workflows in Project Toolkit - Expected Behavior?
I am working on editing a project toolkit (similar to Smartsheet's PMO template set) and several workflows are set to "send to specific people". When my colleague tries to save the entire toolkit folder as new all of the workflows that are set to send to specific people break. The workflows are still there, but there are…