-
Why would a formula work on one sheet but be #unparseable on another?
Hello All, I am trying to use a formula I use on one of my sheets to collect data. It works great, but I made a new sheet to capture the data as the other one is messy as I was still learning. My Formula works great on the original sheet, but when I use the same formula on my new sheet it comes back #unparseable. This is…
-
Helper sheet no longer populating
We have a helper sheet that absorbs certain orders, entered by a form, to fill another sheet. It is no longer populating. The only thing I know has changed is that some column names on the main sheet had been altered in order to set up an automation for a totally different sheet. Nothing else appears to have changed. Would…
-
Copy a date in a cell that is formated as a date
Hello everyone, i have a layout where project managers fill in all relevant information into an intake sheet. And then i have created some formulas and automation so that the project sheets would fill themselves upon creation. So far so good. Now I have different date columns in the project sheet that need to be filed in…
-
How do I include the parent row of a task that is being triggered by a condition event of the task?
My project timelines are separated into parent / child relationships, with the description of the component in the parent row, and the description of the task in the child row. The child row is triggering an email to the project manager based on the condition that the end date is in the past and status in not completed. I…
-
Why are my workflow notifications not coming over as my name via Smartsheet?
I have my automated workflows set up to "send from triggering user." However, I have made a few updates, as well as others who have triggered the workflow, and the workflows show in email as from "Smartsheet Automation" instead of from "triggering user name via Smartsheet". I have been playing around with it but can't…
-
I need to automate sheet creation
I see the generate document option, but I need to be able to automate the creation of a new sheet from a sheet template.
-
How to trigger dropdown to populate projected completed date based on specific complexity?
I want to trigger these drop downs in the "Complexity" column to populate a date in the "Projected Complexity Completion" once a dropdown value is selected and once status changes to "active". Low Complexity = 2 days Medium Complexity = 5 days Most Complex = 10 days
-
Tracking the Specific Time of a Cell in One Status
Hi all. I am trying to simply and easily track the time in days a cell is in red status (General Health column in picture below) until it changes. Nonetheless, although we can easily keep track of row changes with helper columns, I really cannot figure out how to do so specifically for one cell. Any recommendation on how…
-
Workflow Automation
I have a form connected to a sheet (~140 rows of data) with automation and approval workflow. I need to make changes to the process so I deactivated the workflows while I work on the changes. Question - When I reactivate the approval workflow and other automations will it send an email for all the prior items? Thank you,
-
Automation column to column
I would like to automate the behavior of columns. My case is to create a list of our department's contacts as task assignments and in a separate column note the team the person is on, so, for example, Jane Smith is on the Marketing Team, and John Doe is on the Operations Team. Then I would create a USER REPORT for tasks…
