-
Using an Automation to Duplicate a Row in the Same Sheet
I have read several posts that suggests that this is not currently an option. I have a sheet which contains a list of evaluations. Sometimes we have to complete a second, or even third evaluation of the same person. Each row represents a person and their evaluation. If we have to do a second evaluation then much of the…
-
Printing the gantt chart
Hello, Is there a way to print ONLY the gantt chart and not the columns? Thank you!
-
Return Current Month in Cross Sheet Formula
Hi all, I need to pull counts of events related to account #'s for the current month. On the raw data sheet, I have the row calculation working with this formula: =COUNTIFS([Event Date]@row, IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), [Event Date]@row, IFERROR(YEAR(@cell), 0) = YEAR(TODAY())) However, that will just return…
-
Recurring Alerts/Update Requests for an entire sheet.
Hi, I have noticed that the criteria for sending update requests to an individual in a 'contacts' column can be set for a specific date, but I am looking for the ability to send a routine monthly reminders/updates to these individuals on a recurring basis. It appears the functionality for routine updates exist at a Row…
-
If cell in column contains "ASAP", change value of cell or match another cell's value
Hi Smartsheet Community! Issue we are trying to resolve: We have an intake request form that provides the client with an opportunity to request a preferred start and end date range or fill in with "ASAP". However, when the client enters in "ASAP" it causes the Requested Work Week column to have an error, which causes the…
-
Automation
Hi everyone, I need to delete duplicate rows in a sheet. How can I create an automation to delete one of the "n" duplicate rows? How can I create an automation that deletes a row completely under specific conditions? Also, is it possible to highlight duplicate rows with conditional formatting? Thank you!
-
Make a link reference in a sheet to data in a report?
Hello, I want to link data from a report (a grouped sum amount) into a sheet with a reference link and/or add it to a formula. How can I pull data from reports to use in sheet formulas and/or rows/columns? Thank you, Angela
-
Mail Merge directly from smartsheet to Outlook/Word
I would 💕 to be able to mail merge directly between Word and a smartsheet source to send targeted emails with sheet details.
-
Can I automate sub task numbering
What I'm looking for is to assign ascending numbers to each sub task, starting from 1. Like how I have included in the photos. Update: I found the threat where people are talking about the WBS template. If you're reading this and you have not found it yet, here is the link…
-
Collapse Hyperlinking Search Box
When you insert a hyperlink to a Smartsheet Item, and click <select sheet>, the menu defaults to all workspaces and folders expanded. Although you can use the search box at the top to filter the list down, it is still cumbersome if you are trying to link to a sheet with a common name like "Issue Log" or "Project Plan". I…
