Cell linking
Discussion List
- Is there a way I can easily reference a single column from a wide Sheet Range Reference? I have 50 columns on a separate sheet, each one I need to run a COUNTIF() on. Rather than creating 50 range ref…
- Hello all, I have a sheet that I'm trying to get the elapsed time in days from when a ticket was open to when it was closed. I am doing this using a second sheet, so the formula uses sheet references.…
- Hi, I'm pulling two excel sheets into SmartSheet. Sheet 1 is called the MASTERLIST Sheet 2 is Called the SALESFORM. The SALESFORM pulls data from the MASTERLIST. What I want to happen is in the SALESF…
- I have 3 sheets, one for marketing, one for sales calls, one for training. How can I combine the dates/items from each sheet onto a master, to create a master calendar that I can then export to ical a…
- Hello, We are experiencing an issue with the chart functions within Smartsheet. We are currently using Smartsheet to collect and process help desk tickets. We have a form hosted on our intranet where …
- Hi all! I want to create a checklist for the cleaners who turn over my airbnb properties. I know how to create this checklist but there are a few specific things that I need it to do and can't figure …
- I would love to create and manage Google Campaign URLs with Smartsheet. Ideally, I would enter the URL and associated variables, and in the final column it would generate the complete campaign URL, ju…
- Hello, I need help with the following. I am buildig a sales pipeline tracker. On one sheet I have a list of master accounts. On the tracker sheet I have a column named account list. Can I do a lookup/…
- I am trying to grab data from my dashboard metrics sheet in such a way that data is associated with the selected column header, as opposed to the actual column header. I am trying to use the Metric Wi…
- I've created a VLOOKUP formula to pull in data from a source smartsheet, into a 'staging' smartsheet but, if more than one row match the criteria, only the first row entered in the source smartsheet g…
