-
How to search , and match the couple data from 2 sheets and result show on 3rd sheet
Dear All, I'd like to calculate Total stop time of each machines per day. I have tried to find out the solution for search and match the couple data from 2 sheets and result of the couple data show on the 3rd sheet but I am failed. Anyone please help me, how to match and pick up the correct data as example ? Thank you.
-
URL Query String with Dynamic Data Connected to QR Code?
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 "current stock level" value so the person knows how much they are able to check out of inventory, but the team using it wants…
-
How to send an automation to multiple contacts in another sheet?
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 changed to email y tomorrow). Sheet B has an automation to request an update when a row is updated. How does Sheet B sent the…
-
In need of human brain to resolve AI formula.
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(YEAR(VALUE([Delayed Result Date]@row)), MONTH(VALUE([Delayed Result Date]@row)) + 1, 0) I'm getting a #INVALID VALUE error The…
-
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))
-
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?
