-
INDEX/MATCH formula assistance needed
Hello. I'm using the following formula to match resources with their resource manager (=INDEX({Resource Manager2}, MATCH([Assigned To]@row, {Resource2}, 0), 1) ) and it works great for a 1:1 scenario. However, I have a many to one, or many to many scenario and I need help modifying this formula to accommodate both of them.…
-
Forms Help!
So I know that there is no way to align submissions with specific cells, but has anyone found a creative workaround for this that still allows you to identify the submission with proper trigger data?
-
Resource report gantt chart
Hello! I need to create a report to visualize resource utilization per project over time, similar to this: https://community.smartsheet.com/discussion/76598/how-do-you-track-parallel-projects-and-show-overlapping-resources Some important context: I do not have access to resource management or resource settings. All of my…
-
JOIN with 2 columns that are NOT next to each other, and "force" order
I am (trying to) using the JOIN function. It works but NOT the way I want it to. First, the columns I wanted to join were not next to each other. I am attempting to join 2 columns in a specific order and NOT the column in between. What am I doing wrong? They need to be in this order as the essential piece of data is the…
-
AND(Contains(...), Contains(...)) Functioning
Hi all! I have a question I have not been able to fully decipher with the documentation. I have been trying to identify if a certain combination of values in 2 columns appear in 2 other columns from another sheet. (Let's say I search value A in "Alphabet" column; and value 1 in "Order" column: I want to find out if the 2…
-
Is it possible to change the Source Sheet from Reference instead of individual references ?
Dear Smart Team, How can we modify the Source Sheet name from the Reference instead of modifying individual references. Scenario. I have created more than 50 References use this reference in different formulas. For Example Question and Answer. Reference "Ans 1" for Answer 1 and "Ans 2" for Answer 1 and so on, till 50th…
-
Smartsheet Tags
Does SmartSheet have a tagging feature? As I input information into a column, I want it to auto-populate as a drop-down criteria for that column. This would be more efficient than creating a dropdown list manually.
-
Drop Down List not populating (Mobile Version)
Hello i have a quick question and was wondering if anyone was experiencing similar issues and have found a work around. I put together a checklist for our MHE and would like to post a QR code to the Smartsheet around our facility. The issue i am experiencing is one of my columns with a drop down box is not populating on a…
-
Are you able to hide specific rows from people on a shared sheet?
Hi, I am working on building a sheet for our CEO to track employees tasks and deliverables. However, he wants 1 sheet with multiple viewers (the team) and to be able to make the sheet so that each team member can only see the tasks (rows) they are assigned to and not be able to see any rows that are assigned to other team…
-
Ability to Move Child Rows to Different Sheets Without Breaking Hierarchy
My team is currently hindered by not having the ability to maintain hierarchy while moving child rows to a different sheet than the parent row. I have built a complex system in Smartsheet and so far this is the only problem I have not been able to solve. Hoping this will become a possibility in the future!
