-
Have two auto-number or rank by created date?
Okay, so I have been working this problem for a few days and it's officially making me crazy. Here's the problem statement: I have 3 intake sheets for different business units. Each has an Auto-Number column that has a prefix for the BU. I need to consolidate all of the attachments from those 3 sheets into 1 sheet. So on…
-
Automation disregards conditional logic and copies every row
Greetings Smartsheet Wizards… I have created an automation that is supposed to only copy rows if a particular column is blank. The conditional block is set to "where column name is blank". However, the automation copies every row in the sheet, even the rows that contain text. Does the is blank condition not work correctly…
-
Potential reasons why my trigger is not resulting an event during run log (Bridge)
I've completed the authentication process, created a trigger and made sure that the trigger has the right source sheet and event type but I am noticing that I can't get any data from the trigger. My goal is to get the row information when new row is added in my sheet so I can copy some of the data over to another sheet.…
-
Merged: Select columns feature in "Move a row" automation
This discussion has been merged.
-
Copying a new entry (not a row) to another sheet.
so i have two sheets. one sheets is for new hires that we manually enter the username. we have taken over another group which they fill out another set of new hires from another department. i want to copy that new entry not the entire row because i need to map their info which has a different column name then the column…
-
Revamp the navigation to assets when copying rows to another worksheet!!!
LOVE this!!! Can we PLEASE have that each time we need to navigate through our browse button??
-
Copy few cells from 1 sheet to another based on a filter
I have a sheet named "T1 SQDVP", and I want to copy the "Safety Details" data from this sheet into the "Action Log" sheet, creating a new action under the "Follow Up Action" column. Based on the filter when Column "Safety Action / Escalation" is selected as "Action Required at Tier 1" See screenshots. Any suggestions would…
-
Can't use Vlookup or Index Matching
Hi all, I have a sheet which is organising workflows for different departments. Departments are separated into different sheets since they have different tasks and metrics to monitor and some activities are sequential therefore moving once finished with one department by automation. How can I get row info from 1 sheet to…
-
Mysterious strikethrough being added during automation process?
Sheet 1: team manually enters weekly updates to dates and metrics Sheet 1 Automation: weekly Friday morning trigger to copy all rows (~5-15 rows) from Sheet 1 to Sheet 2 Sheet 2: ledger of all updates made week to week Report: Pulls in Sheet 2 from 12 projects, displays 8 columns, filtered down to just the prior 2 week's…
-
IDEA for Copy Row Automation: Also Copy Assigned Dropdown Value Colors
If Colors in a dropdown column are setup (In Table View), the Copy Row automation should retain those same colors when copied to the new sheet. Just like how cell colors copy over, I'd like those assigned colors to copy as well.