-
VLOOKUP and Large returning Correct value but wrong Description
I have the VLOOKUP set up but it’s returning the wrong result. For example: According to the Large function, 6,990 is the amount that we’ve spent the 5th most on so far this year, when I scroll through and find that total, it’s the Sidelaster Conversion that show's we've spent 6,990, however it comes back as the BDF Boxtoe…
-
Vlookup with Large formula as the search value
SOLVED* REALIZED THAT I HAD AN EXTRA ) IN MY FORMULA!!! Hello everyone, I have a list of items that pull from other sheets what we're spending on each one. From there, I have used the large function in a cell to pull the largest totals and rank them from 1 to 5 for a "top 5 spender list" I would now like to pair up what…
-
Sorting Rows
Hi, I am working on something that requires to sort the Smartsheet based on a column. The type of column is 'TEXT_NUMBER'. 1/0/12 1/0/1 1/0/14 1/0/3 1/0/11 After sorting the smartsheet with the above column the result is this 1/0/1 1/0/11 1/0/12 1/0/14 1/0/3 I am using python sdk in my project, but it doesn't sort all the…
-
Sum of Totals by area and Date
I am trying to set up a formula that does the following: If in Work Log A, the Plant is X and the date range is between 10-1-2020 and now, what is the total cost of this time range for this sheet? I also want to break down by monthly range: If in Work Log A the plant is X and the date range is between 1-1-2021 and…
-
Formula help to return differnt conditions
Hi I am after help in developing a formula to look for certain conditions. I require the highlighted cell in blue perimeter to record certain condition if a condition is true from the 5 cells below. If all cells return Completed then return "Completed" If all cells return Not Started, then Return "Not Started" If all cells…
-
Stacked Bar Chart
I am attempting to create a bar chart widget that summaries hours by department on a given project, but I can't seem to figure out how to get it to display the information I need it to. I have the data set up in a sheet as follows: I would like the graph to show each department's hours as a portion/percentage of the total…
-
Removing rows based on a value
I've created an onboarding training template for new hires at my company using the following (https://app.smartsheet.com/b/publish?EQBCT=2a335ca126274786adde88923187b3ca). I've removed some of the original reporting features and added our own. I need to create a version of this that can automatically remove, and re-number…
-
Workflow Question - Decline with An Attachment
Wondering if anybody encountered the same situation here. I have a very simple mechanical drawing approval workflow that works fine if the approver only click on "Approve" or "Decline" button. The approval column will change to Submitted when drawing submitted (trigger by attachment), and changed to Approved or…
-
Using Index/Match with Two Values in Another Sheet
In Sheet 1, I like the prices for services for different vendors: Vendor 1 | Category 1 Service | $10 Vendor 1 | Category 2 Service | $20 Vendor 1 | Category 3 Service | $50 Vendor 2 | Category 1 Service | $70 Vendor 2 | Category 2 Service | $90 Vendor 3 | Category 1 Service | $30 Vendor 3 | Category 2 Service | $60 In…
-
Version Control of Project Plans/Sheets?
Hello, I am wondering if there is a way in Smartsheet to version control the sheets. Basically, we are using each sheet as an individual project plan. However, as projects progress, the plan will (usually) slip and/or have to be updated, so we need to amend it. Since there seems to be no way in Smartsheet to baseline the…
