-
Used in Formula for <unknown sheet>
i see this everywhere. i know its from when i delete projects and such, they will leave this leftover trace/breadcrumb ... but why? And does this impact performance? some cells in some sheets have tons of these, so im just wondering why they dont auto remove themselves or how to easily manage those as opposed to clicking…
-
Can I write a cross-sheet formula that works if one has one and the other has many?
Here is the use case: Smartsheet A: Lists selected clients once per row (includes a column with a unique client ID). I created a drop-down column for each product with yes or no picklist. Smartsheet B: Lists clients on many rows (includes a column with a unique client ID). I developed a formula to enter "Yes" IF the the…
-
Sheet Summary % Complete
I am feeling silly that I can't get this to work. I want to get the % complete of my project based on those with the status of "Complete" divided by all columns that have text in it. =COUNTIF(Status:Status, "Complete") / COUNTIF(Status:Status, ISTEXT(@cell))
-
How do you standardize addresses in Smartsheet?
Has anyone found a way to validate their address fields in Smartsheet? We are currently using a Smartsheet form to collect business license data and would like to integrate our data to ArcGIS to map the business locations. Currently, we are manually updating all of the citizen-submitted addresses which is a huge time suck.…
-
zip Code Radius Help
Hello Everyone!!! Hope my question makes sense. But I am trying to figure out if there is a formula that can provide me a Max Distance radius from Retailer formula that shows the max range in which we should set our radius targeting for these retailers. I have the retailers full address, Zip, Lat and Long so I feel like…
-
How do I sum cell values in a column up to a specific sum, and return the adjacent cell value?
First time posting a question, fairly new to smartsheet. I have a spreadsheet in googlesheets that does what I need, but as we are moving over to smartsheet with a lot of our other work, I would like to get this set up in smartsheet as well. We grow sweet corn, I have data that I use to make planting schedules and predict…
-
COUNTIF and HAS functions not working on multiselect columns
Hi! I am having an issue with using the COUNTIF and HAS functions together to count all instances in a select all that applies column. I'm specifically using this on a metric sheet to add it on my dashboard. Any ideas on what I'm doing wrong?
-
Countifs and NOT(ISBLANK)
Hi, I'm hoping someone can point me in the correct direction. I'm trying to get a Count of the amount of unit of a specified category if they are not yet assigned. Basically, I have Column "STOCK" that I want to count what is assigned in box SEARCH201 if "ASSIGNED" is empty. This is what I have so far:…
-
Cant figure out Summing 2 columns based on text in another
I'm trying to sum up two budget columns, based on the budget type in another column. For some reason I keep getting errors and can not figure this out. =SUMIF(Program:Program, "BDM", [PO Raised]:[Planned, not POd]) Program Column = Text/Number = "BDM" PO Raised & Planned, not POd columns are also text/number columns that…
-
Can you use the IF functions on drop down lists?
I am wondering if anyone has used multiple dropdown list columns that are essentially parent, child, ancestor so if parent column choice is ... then child column choices are .. and if ... ancestor choices are Thanks. MoFo