-
Email flexibility - a CC option
Hi There - part of the function I use Smartsheet for is notifying folk around changes. This almost always includes a specific recipient and a number of FYI's. Currently all recipients are at the TO: level in any email, it would be elegant if there was a CC: option as well. Although I probably wouldn't use it Bcc: field…
-
Copy Rows to Another Sheet not working - Column has the same name as a system column on the source
Help please. I am trying to set up an automation that copies data from my Main Purchase Request Sheet to my Line Items Sheet. However, I keep encountering an error message stating, "Rows can't be added to the destination worksheet because a column has the same name as a system column on the source sheet." Here are the…
-
Why does my date automation disable with work management connected to column?
I have a intake sheet. When a new row is added, automation records the date in a column. I want to use the project added column as a start date in the Resource Management but I get a error shortly after when connecting, saying automation is now disabled. Is there something I'm doing wrong or I can be doing differently?
-
Workload tracking in Smartsheet with Parent Rows only
Hey, I'm so lost lol. I want to use the Workload tracking but read a article that allocation only worked with Child rows. My intake form doesn't have allocations. I'm trying to understand how or if this can work on a tracker with only parent rows. I also have automaton when the row is copied from another sheet for the job…
-
Report Creation tool within a sheet
One of my most frequent uses of Smartsheet is as an editorial calendar for a weekly newsletter. I create a new sheet for every month of the year. Exiting a sheet and creating a report is not too much of a hassle but, it would be nice if I could click a button within a sheet that automatically opens a new page that is a…
-
Hierarchy automation workflow - subtasks inheriting data from parents
In the automation workflows, we need an action that will allow us to drive hierarchy related automations. The obvious one that lots of people want is to simply inherit data from parents. Using formulas in the sheet view is possible, but it's limited and very clunky. I've attached a simple image showing what I would want.…
-
Assistance Needed with Date Archiving Automation
Hi there, I have a helper sheet that populates Office drop-down dates via DataShuttle. The "Date Requested" column contains drop-down options with dates, and the "Date" column is a date column (my trigger for moving rows. I want to archive each date row if it matches today’s date, but the automation I set up isn’t moving…
-
Sequential Numbering Autopopulate Row
Hi all! I am trying to create a formula where every time I add a row, it aligns with the next number in the series. If it reaches a level 1 row however, the series goes to the next whole number. I wrote out manually what the numbers should be but I would like a formula to apply this automatically when i add a new row. Im…
-
Populate Column With Unique Values From Another Sheet
Hi all! I have a sheet, where tasks are entered and assigned to employees. Every task belongs to a certain company, which is specified row by row (every row is another task), this describes the first sheet we'll call "Requests". I want to create another sheet to summarize the data of every task for every company, this…
-
Concatenating values from two columns with 20 spaces between them
Hi guys, I have a task to concatenate two strings from two different columns with formula. The values are for example SEA129 and 01. What I want to achieve is a string which will look like this "SEA129 (20 blank spaces) 01" Has anybody encountered similar issue?
