I have the following formula checking for matching emails in two sheets & returning the date: =IF(Done@row = 1, INDEX({Submission Date}, MATCH([Email Address]@row, {Submission Email})), "") It's insid…
HI, I have a smartsheet form that connects to an intake tracker. However, when the form is submitted it moves the form data to random rows and now row 1. Does anyone know why smartsheet does this or w…
Hi, I haven't actually started this in Smartsheet because I don't know where to start. I have an inventory list (excel) that itemizes on multiple rows against one PO#. Like this: Line 1. PO# 12345 Ite…
I've duplicated the same sheet to contain completed project rows according to fiscal year. I've needed to change the order of the columns in one of the sheets and would like that same order matched to…
Hello, I want to create a dashboard widget that will show employee FTEs for the current month. I currently have a sheet (Capacity Plan) that list out the employee's name, and then has the assigned pro…
Hello! I have a software enhancement sheet, and I am trying assign priority to each enhancement based on the level of effort (LOE) + change priority calculated score. The LOE can be one of the followi…
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Co…
I want to be able to enter the Name and Email Address components into a Contact List column type field on a form. Is there any way to do this? Or even to create a formula in the Sheet that will calcul…
Hi there, I'm trying to figure out how I can count the number of projects for a brand have a specific status out of the total projects for that brand. Also, I'm referencing a different sheet for these…
Hi there, I have a setup where I have a sheet. I need to import Excel data to this sheet weekly. The sheet and the Excel file have the exact same column names. The data has 145 columns and around 450 …
