-
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…
-
Hyperlink Color on Dark Background
Hi, I'm new to SmartSheet so I may have missed something. When I add an hyperlink on a cell with dark background, is there a way to make the text white or any other color that would allow to read it? I thought the automatic mode would change the color, but it does not let me do so... any ideas? Do I have to stick with…
-
Users and Accessing Sheets, etc.
Hi - thanks for reading this. I'm trying to find some files and asked for access. Was told to search the backend of Smartsheet. (IS there a "backend" of Smartsheet?) I'm not a system admin. I think that means I can't see anything not in my workspace. Is that correct? If you're not shared on sheets, can you see all sheets…
-
Reference another sheet to return quantities from multiple rows
Hi all - I am building sheets with corresponding forms to allow individuals to receive and distribute supplies across several locations. What I need: a master inventory sheet reference other sheets, specifically for an item name and the quantities received. The quantities received will have multiple continuous entries…
-
Free Webinar: Forms Best Practices
Join us January 13th for our webinar "Forms Best Practices." In this webinar, you’ll learn best practices for creating, customizing, and sharing Smartsheet forms to collect and capture data. We will be hosting 3 sessions across multiple timezones, if you are not able to join us live, feel free to still register and we will…
