This discussion has been merged.
So recently some of our users have began receiving duplicate email and request alerts. If this is an automation programming issue, I'm not understanding what is causing it (I have been using the same format for all of our vendors and workflows without this problem). Is anyone else experiencing this/have any advice on how…
Hi Guys A quick question (if there is such a thing); when adding a link from one sheet to a cell in another sheet do the column headings have to be the same? My assumption would be they don't, I imagine the column name 'internally' is irrelevant and there is an underlying system generated reference, otherwise changing a…
Hi Smartsheet Community, Is there a way to set up the Copy Rows workflow in such a way that it will only copy select columns to a second sheet? Certain staff will be inputting information into 14 columns on a spreadsheet, but I only want 12 of the 14 columns to copy to a second sheet, as two of the columns may contain…
I'd like to set up a conditional monthly notification to my Regulatory Staff. Here is some context. The notification is to remind Regulatory Staff to reach out to study teams that are working on a clinical trial for which no annual continuing review is required. I have a column that either has the IRB expiration date or it…
When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row? I saw in a post from 2020 that this was not possible yet. Is this possible now in 2023?
I created a Smartsheet for a team calendar. I created a Form attached to the Smartsheet for the team to request new "events" and be able to get them added to the calendar. Then, I created an Automation Process for Approval when "rows are added" and set it up to leave the row upon approval and delete the row upon rejection.…
Is there a formula/ methodology to auto number parent rows only, preferably with a prefix style numbering sequence like the Autonumber column type uses?
I have a sheet where we log our support as it comes in. I have a "completed" check box to check once it is finished. It also has a date created field. I setup a second copy of the sheet. On the first sheet I added automation to move any row that is "completed" and over 3 days old to the second sheet. This works well.…