-
How to include existing data in a 'copy new row' automation.
Hi! I have a use case where sheet A needs to aggregate data from sheets B, C, D, etc and was going to set up an automation to copy any new rows from sheets B, C, D, etc. to sheet A as specific criteria is met. My question is, if I already had data on sheets B, C, D, etc. how do I get that to copy over to sheet A? Do I need…
-
Copy Row Automation causing duplicates
I am using an automation that copies rows which contain the word "submittal" into a sheet where we are tracking submittal dates for all our projects. I cannot use a report because we need to be able to publish to a calendar. Therefore, the end result must be a sheet. As most of you probably know, these dates can change…
-
Double link from cell in other sheet works erratic
HI, I've created a program management tool where we can manage all our different projects. For the moment i'm working on a Charter approval flow, in different stages. Each project manager has his own Workspace, where all his projects are stored. Everyone has at least viewing permission on all projects. All projects are…
-
Is there an issue with Copy Row Automation?
Hi, I am struggling with an issue (bug?) that doesn't display newly copied data using the copy row work flow function and would like to know if any one has come across this? We have a sheet with vlookup formula which returns some data from a metrics sheet. In this vlookup formula sheet there is workflow which copies this…
-
Task Management / To-Do's: New Email Push to Smartsheet
Is there a way to forward a new email from outlook to smartsheet for automated entry into a workplan? I have a To-Do list by using a simple grid format. I am curious if I can forward an email to a targeted address that will create a new line in a grid/workplan/list
-
Complex Time Calculations - difference between created dates
Hi, Having an ongoing battle here with trying to work around the system generated "Created" date/time stamp. I want my guys to fill in a form when they start and stop doing work on a project in our production line, and then evaluate the time spent on each serial number job. My grid of sample responses looks like below: You…
-
Is this even possible?
I have a process document with columns with start dates and due dates. The process steps do not change from year to year. What I would like to do is trigger some action or create a formula that once an item is checked complete, the start date and due dates advance by 365 days. It would be great if the complete box was then…
-
Automatically Generate documents
Is there a way to automatically generate a PDF when a row is added to a sheet?
-
Form Resubmissions
Good evening, I'm posting again in the hopes that someone can help me with an issue. I have a form that is being used to route matter closing requests from the attorney to Accounting to Records. I have a number of forms that were submitted (entries in the SmartSheet) but never went to anyone in Accounting because the email…
-
Automatically adding rows to sheet and automatically nesting them under parent row?
Is it possible to have a rows automatically added to a sheet (for instance from a form on another sheet), and have the rows automatically be nested under the correct parent row on the target sheet? For example, if the Primary column is "project name", and "parent project name" is a field on the form, is there any way for…