Sign in to join the conversation:
Hi, I have successfully setup an index/match with 1 sheet but I need to add a 2nd sheet for the index to search as well. How would I set this up in the formula? I tried to notate both sheet's columns for the range but keep getting an error.
Thanks
Could you post some screenshots so we can see what exactly you are working with?
Awesome! That totally worked!
Thanks everyone for all your help.
?!?
Is there a way to move attachments from one sheet to another based on key data? IE: We have a sheet that includes a lot of the 'pre-completed' process, and final product PDFs are uploaded as they're created. We then have a sheet where we track information related to the final products. We don't want to use Move/Copy as it…
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
