I am trying to link cells to another sheet (Name column) based on the specific local chosen that they are in (Local #26). I have tried using this formula below, but it only populates one name not the …
I want to get a dollar amount based on if a checkbox is selected. I am running a program where participants can get gift cards as incentives. I am using a separate sheet for the amount for each incent…
Hello, I am trying to write an INDEX MATCH formula that will return a due date on my metric sheet while referencing a much larger projects sheet. Currently, my metric sheet has two columns: "Project D…
Hello, I am trying to create a smartsheet formula to aggregate summery information from an amendment sheet onto a master sheet. However, when I attempted to use join() +collect() my cell returned all …
Hi. For the past few days, I've been trying to create a dashboard to track the tasks that each member of my team has. I learned that the best way to do this is to create a separate sheet where I used …
This is my current formula that is producing error - Unparseable, I can't seem to figure out what the issue is. =OR(IF(INDEX({Min_Skill_LTT}, MATCH([Job TItle]@row, {Minimum Skill Requirement Range 1}…
I have a sheet that displays information that is valuable as both a grid and a calendar. It would be nice to be able to make a "copy" that is a linked clone of the original sheet in a locked-view vers…
Hi All, I have a master data sheet collating uniform info + delivery addresses. All fields work but for some reason half of delivery details come as #INVALID VALUE - Not sure what is the issue or how …
I am trying to bring across the latest submission from a pre start form to a main master sheet with up to date information. Currently i am using the formula =INDEX({Pre Start Check current hours}, MAT…
I've been tasked with creating a workflow or function that lets Company 1 add rows (sales leads) containing simple client / salesperson data, and status of the lead. Company 2 would then access a shee…
