-
Disabling sheets, reports and/or dashboards without deleting them
As a company, we are trying to determine what grids, reports, dashboards, etc. that people are using. Is there a way to disable items without deleting them? That way if it is decided that we still need something, we don't have to recreate it.
-
Sheets set up
Hi Experts I have a question. I'm wondering, what's the best way to set up my sheets. I have a Tracker A which gets input from customers during the year (Q1-Q4) The Tracker has several columns first 10 are general columns which are the same for each quarter and than I have 20 columns to be entered by the customer during…
-
Locking Columns/Drop Down Lists
I need to be able to protect formulas in a column for the parent rows but still want people to be able be able to select child drop down cells. If I lock the column will this stop people from being able to use the drop down lists? If so what other options do I have to protect the parent rows' formulas?
-
Combining data from sheet in a dashboard chart
Hi everyone, I have a form that I use internally to generate analytics. I am manually adding a certain "amount" per day. I want to visualize how much "amount" I have accumulated per month. The form has a "date" and "value" property which get added to a sheet as "Date" and "Amount". I created a helper column to calculate…
-
Help with returning Yes value if multiple criteria is met
I am trying to identify which RED customers from one Sheet 1 have already been added to our CEM (Customer Escalation Master) Sheet 2, so I don't have to manually spot check between both. I created a new Column called, "On Escalation Master?" and want to return a Yes or No value. I am getting #UNPARSEABLE error when I try…
-
Map for Location Data
Hi, Is there any map feature that Smartsheet provides (or third party) to show on a map data of a location-column on a Smartsheet? Thank you!
-
ad sheet to report automatically
i have a folder under "sheets" that has all my ongoing project. i made a few reports that sum up info from all sheets my problem is that every time i add a sheet to the folder i need to manually add it to all my reports how can i make it that every sheet i add to that folder will automatically be added to a report?
-
Referenceone sheet and if 0, reference another sheet
Hello, I've been using smartsheets for several years now but really only starting to use formulas until recently so forgive my lack of knowledge. I have three sheets in play here. The primary sheet is looking at the second sheet for an average based on all references of a SKU. The second sheet might not have data for a…
-
VLOOKUP separate sheets
I would like reference sheet A zip code with zip codes in Sheet B, and when there is a match change a specific column status in sheet B sheet B status
-
Change a cell value If a certain Postal/Zip Code is entered, is it possible?
Hi there helpful people! I am using smartsheet to track jobs in order to then export a monthly report. I have approx 2000 postal/zip codes attributed to client sites within a particular State - and what I'm hoping to do is set up an automation (either within a workflow or a formula) where if a particular postal/zip code is…