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?
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…
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…
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!
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?
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…
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
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…
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…
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…