-
Clone cells or rows?
Hi All, Hope you are well. We currently use Smartsheets as part of our product management and planning. We have a Sheet with all our current development work some of which has been started and some of which has not been started, the problem is this sheet is getting quite big with all our current and upcoming work its named…
-
How can my index/match formula include a column that has multiple values
Ok so I downloaded an inventory management template that is awesome! When people submit a request form for a ppe item they need, it has index/match forumlas to show us what Current Inventory remains. Its great! However, they are only able to select one ppe item from the drop down list. And I need them to be able to select…
-
How to turn on notifications for sign-ups?
I have created a SmartSheet sign-up for an event I am hosting and it looks great. However, I am not receiving notifications when people sign up with the sheet. Instead, I've been refreshing the page every morning. Is there a way to turn on notifications for sign-ups specifically within a sheet? I've already gone into my…
-
#INVALID COLUMN VALUE error
Hello Community, I'm trying to combine two formulas but keep getting an error. The first formula sums children if it's a parent row or leaves the cell blank. The second look for the most recent data in a row (I have month in the columns from July to June). They work independently but when I combine them I keep getting an…
-
"copy row to another sheet" - Sometimes row gets copied down at the bottom?
Hi, When there is a workflow to copy a row to another sheet, why does the copied row sometimes appear down at the bottom of the sheet, leaving ~50 completely empty rows in-between the last row or text? I know technically smartsheet must be sensing that the rows in-between are not empty, but does anyone know what causes…
-
Anyone else have this issue with forms and know how to resolve?
I am having a problem with forms submitting into a SmartSheet. I've built a simple SmartSheet with some IF commands that apply a score based on dropdown menu answers. I also created a report that shows a selection of columns based on a field being populated. When I submit a form built from the simple Smartsheet, nothing…
-
link between sheets
Hi! I'm working with two different sheets. The first one has all marketing activities (webinars, events, trade show, etc). The second one has all the marketing assets created (Ebook, social media cards, etc). I would like to link which assets can be used for which marketing activities. A marketing activity can use more…
-
Include Help Text on Form Submission Copy
My organization currently has a site visit assessment form. Many questions on this form are too long for the sheet column headers, so the columns are just labeled Question 1, Question 2, etc. The actual question is then put in the "Help Text" field on the form. Many leaders who fill out this form opt to receive a copy of…
-
Header
I want to add a fixed header that displays above rows on my sheet. I see this is available when printing the sheet, but I need to add instructions and clarification to the published sheet that is viewable by collaborators.
-
Clone Workspace with link
Hello, I was going through the Smartsheet Academy and saw a page where SS displayed a link and if you select it, it would automatically clone a work space for you without having to manually clone. I'm currently making a dashboard depository of our workspaces we would like all employees to use as templates for projects to…