-
Vlookup functions not working on a Master Spreadsheet
My colleague and I, who do extensive work on a master spreadsheet that pulls data from many different sheets, are having a lot of trouble with the vlookup function on this particular sheet. We use the vlookup function in multiple different columns on the spreadsheet in question, pulling data from a different source sheet…
-
Is it possible to automate export of specific cells on a triggered event?
When our "Completed" column is checkmarked, we wish to export that row and its children rows to an external file such as .csv, Excel, or Google Sheets. If possible, we would also like to export the attachments for those rows as well as reformat this data. Is this kind of automation possible? Built-in, 3rd party…
-
Webhook events
My company is looking for a way to export a project's data (including attachments) when it is checkmarked as complete in our projects list sheet. We would like to append this information to an excel spreadsheet or a google sheet. The workflow that I had in mind is that when an order is checked as complete, it triggers an…
-
Hide Divide by Zero Error
Hello, I am having issues with creating the correct formula that calculates the average of the children rows while hiding the divide by zero errors for columns that do not have any data. Could someone please help? I tried the following =IFERROR(AVG(CHILDREN([Column]@row],""))) Thanks so much!
-
Median formula showing highest value from range.
Hi everyone, I have two sheets, a master sheet with cost data and a metric sheet with formulas to get a summary. In metric sheet, I need median value of certain items. I have used MEDIAN & COLLECT. Problem: When I updated the formula, I got the correct median value. But after sometime, the metric sheet gets refreshed…
-
The correct VLOOPUP formula?
Hello I am needing a formula that will pull an employee level and assign it to the alias listed. I have used differed variations of VLOOKUP and nothing seems to work. Breakdown: Sheet #1 will contain a list of an employee alias's, sometimes the alias will be listed multiple times. In the column "Level (Formula)" on sheet…
-
"Send" row function now requires paid license - no advanced warning
Why were we not informed about this? Copied below is the exact email I received from Smartsheet Product Info on September 17th. This is very frustrating to have a functionality stripped with no warning. We ran through this list with our teams to determine whether or not any of our free users would require an upgrade. This…
-
If/then statements and automation
Hi team, I'm struggling with a request. Not sure if it's a Friday burnout or not. I was asked if we could populate one column of a sheet with a value if it could change the value of a different column. Ex: when selecting a percentage complete value (0, 25, 50, 75, 90, 100), would like for value selected to populate Phase…
-
Is there a way to auto-group form submissions/rows on the source sheet?
By default, the information that is submitted via a Form populates the Sheet's rows in oldest-to-newest order. I'd like to have the information submitted via the Form auto-group/sort according to the values in one or two of the Sheet/Form fields once it is populated to the Sheet. Would anyone be able to guide me on whether…
-
VLOOKUP Formula
Hi Smartsheet community! This may seem like a simple question but I cannot figure out this formula for the life of me. I am trying to do a basic VLOOKUP formula. On sheet #1 I will have a column that lists employee alias's and a column that will VLOOOKUP that same alias's level from sheet #2. On sheet #2 it will be a list…
