-
Formula to calculate day from a series of dates and times
Hi All, This might be a long shot but is there a formula to search and find a multiple entries of a job number then look for the date column and calculate the series of dates for start and finish time and also include the in and out times to create a Gantt chart? This is all data that will be entered into a separate…
-
Task Manager Master Sheet
Hello - I have various Microsoft Forms creating new rows with requests to different Smartsheets using Power Automate. I'd like to create a "Master Task Sheet" that creates a row with a request ID, Smartsheet name & link, employee name, requested date and "done" checkbox. Could something like that be automated? Or should I…
-
Auto Number Column is Being Copied Over From New Rows
I have a row ID setup with auto numbering on a totals sheets that contains all the copied rows from multiple projects. When the copied rows are inputted into the total sheets (using automation) the row ID is then updated with the row ID from the other sheets. I use this auto number field to identify duplicate rows (and in…
-
Automate Copy of One Cell Only - not the row
Hi all, I'm trying to automate an element of work that I currently do manually. I have two sheets, Project Intake and Pipeline. When a new entry is added to the Project Intake sheet I want it to automatically copy the Project ID cell only to the Pipeline sheet. I then have a datamesh set up to run and copy over only the…
-
Automation - Copy row to current sheet
I have a user-oriented form associated with a sheet. The sheet works as it should, but we have a specific workflow in our business where a user may need to immediately enter a nearly-identical form immediately after submitting the first form. The form has dozens of fields and the second submission is identical in all but…
-
Check a box when a match for a value is found on another sheet
Hi everyone, I have a sheet called Parts Database used to track parts as they go through a production process. Screenshot below. Currently, workers check off the status of each part as they go, which is not practical with the quantity of parts. Ideally, I want them to be able to fill in a response form at the end of the…
-
Template Workspace / Copy Row Automation
I am using Control Center to deploy projects. Inside the template are workflows that copy rows to another sheet inside the same template. When a new project is made I have to go edit all copy row workflows as they continue to point at the template and not point to the new sheets in the new project. Am I doing something…
-
Workflow for Monthly Rollup
Hi! I am attempting to create a workflow that sends a report to an email on the 1st of every month with entries made to a sheet from the prior month -- I can't seem to figure it out. Example: on 11/1/22 an email containing a report of all entries made in October. Thanks for the help!
-
Broken Workflow Report
Is there a way to run a report (or an easy search) which lists which projects (over 300 of them) have a broken workflow, rather than checking each one individually to see if the automations are broken?
-
If Statement to Change Drop Down List Value
Hi all! This is more of a clarification to another question than anything else. I have a column of drop down lists ranging from 0%-100%. With that being said, the default value is blank, if would like to make a column long formula that does the following; if the current cell is blank, set value to 0%, else do nothing. I…
