-
Workflow Automation - Copy Select Cells when Using Copy Row
Does anyone know a method to selectively copy cells to a different sheet using the built-in workflows? Copy/Move row almost does the trick, except there are columns on the source sheet that I specifically want to exclude from the destination sheet. I'd rather not rely on hiding the unused columns on the destination sheet…
-
Trouble using countifs referencing another sheet and adding either "NOT" or an "OR"
I am trying to write something that will do multiple countifs and either include a range of ORs or allow me to exclude rows that have a particular response in a given column. =COUNTIFS({NEOP Tracking Range 2}, [Column5]12, {NEOP Tracking Range 4}, [Column5]@row) This works great. Now I need to only see employees that have…
-
Self-updating report based on sheets in folder
Hi there, Is there a way that I can build a report so that when a new sheet is added to a smartsheet folder, the contents of the sheet then automatically gets compiled into a report? I saw that it was possible to select a folder when building a report, which I was really hoping would have that functionality. But it looks…
-
Can I use formulas to pull in hyperlinks from other sheets?
I want to use a formula to pull in hyper-links across formulas. I started with: =IFERROR(INDEX({Client Intake - Client Invoice Log}, MATCH([Client Name]@row, {Client Intake - Client Name}, 0)), "") but this only pulls in the text of what is in my client intake sheet rather than retaining the hyperlink to the sheet.…
-
Update Sheet 1, Based on Submission to Sheet 2
I have a quick question. I have 2 sheets (Sheet 1 and Sheet 2). In Sheet 2, users submit a form and a field (which is hidden) is automatically checked indicating it's been submitted. What I'm wanting to do is - essentially - notify Sheet 1, that a user submitted something on Sheet 2. My first thought, is to use a VLOOKUP…
-
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…
-
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…
-
Checkboxes to Generate List
Good evening! I need a little help to see if what I want to do is even possible. I am wanting to create a list of people based off of a response to a checkbox. For example, if someone completed a form with their name, address, and other fields to include checkboxes, and checked a box titled 6/7, I would want that person's…
-
Calculation Sheet for multiple sheets
Hi Guys I have a calculation sheet that is currently bringing in data from 3 external sheets in order to be able to create reports and graphs for dashboards etc My problem is that I am conscious I will reach my cell link limit, along with the fact that 3 or 4 more sheets will soon have to be included in calculations,…
-
I would like to copy rows to another sheet but....
I would like to copy rows to another sheet so that other departments can view /work out of the copied smartsheet. What happens if the master's columns are increased or deleted? Is Smartsheet able to match the rows into the correct columns?
