Sheets
Discussion List
- I have three grid sheets, named Sheet 1, Sheet 2 and Sheet 3. The timeline of Sheet 2 is dependent on Sheet 1 timeline and the timeline of Sheet 3 is dependent on Sheet 2. I want a function wherein if…
- Hello! My team is attempting to create a sheet and form that counts the amount of inventory of a product we are overselling per day. We essentially would have the inventory start with 15 units per day…
- My team manages training content for a specific part of our organization and we have content that can be as old as 2016 to as new as of yesterday. For a few weeks now, I've been trying to figure out a…
- Hello all! My company's Payroll team is seeking a task management solution to help them track recurring to-do's related to payroll processing. We are on a 24 period pay cycle (15th and last) and there…
- I've always had issues (in grid view) with the current cell being able to go offscreen at the bottom, but now I'm also having issues with the current cell being able to go offscreen to the right when …
- I am using VLOOKUP in a sheet (call it Sheet2) to pull data from anotther sheet (Sheet1). Then, I'm creating a report that pulls data from Sheet2. This report is pulling some of the data from these VL…
- I'm working on a set of formulas that will find the tasks and list them for the exact matches of the below Department names (among many others). I' have a formula that will work for a few of them but …
- This discussion has been merged.
How to get the same name from two different sheets to populate a third cell based off their response
I have a sheet (Sheet 1) that is being populated with a person's information after they fill out a form. Smartsheet then sends out an email to that person through a workflow to follow-up with them. Th…- I was asked to help with some Smartsheet items (grid, dashboard, and report). I was given Editor (can share with others) for all three documents and I am on an Enterprise licensed account. With the Gr…