I recently built out an inventory system that generates a custom URL query string for each item that partially pre-fills out a form to check items in/out of inventory. The form is meant to include a "…
Sheet A has a column of email addresses, the quantity of which is always unknown (could be 5 rows today, 10 rows tomorrow) and the content is not always static as people change roles (email x may be c…
I have a text column that says the following: 09/2022 I would like to turn this into a date for the last day of the month, like this: 09/30/2022 This is what the AI generated formula gave me: =DATE(YE…
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 ton…
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…
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:S…
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…
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 …
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 das…
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" tha…
