-
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…
-
Maximum Number of Automation Workflows?
I scrolled though here and can't find something to job my memory. I think I had learned it was 50--is that correct? Would be awesome to have a Capacity Quick Reference sometwhere in the Community or Help page. I would bookmark it or print it out to save searching and asking. :) Thanks!
-
How do I dynamically update a dropdown list?
I want to create a multi-select dropdown list with all future dates and this will be sent out in a form. Currently, smartsheet only offers a date selector with one max date. I was wondering, is there a way to upload values into a dropdown through an API? Otherwise, can I upload values into a dropdown from another sheet?…
-
Building contingency into project plans
What is the best way to manage tasks that have a high degree of uncertainty in the duration? An example might be resolving a design problem – sometimes they are quick, sometimes they take a while. A previous software we used, allowed you to put in a best case and worst-case estimate for each task – effectively adding…
-
Automation Condition
I have a form that captures user feedback and sends a summary every Friday for the previous 7 days. I would like to add a condition that if no new feedback was submitted the summary indicates "No new responses were submitted this week"
-
How can I change the priority automatically based on a due date
Hi all, I have multiple rows of materials that need to be released before the due date, I have categorized them in Critical priority, Priority 1, 2, and Regular. Is there a way that smartsheet will automatically change the priority based on the due date entered if my team has not yet addressed the row?
