-
Trying to do a SUMIF formula - Help!
I've been trying all kinds of formulas and can't get this to work right. I'm trying to do a formula with the below that says IF Approved? column = "Yes" then SUM the range of cells (CSM PM + DEV / BA + Arch/Engin + UIUX +QA)
-
Index(Match()): Lookup a price of a product from another sheet but keep historical entries
Hi am am hoping to lookup a price of a product from another sheet based however keeping historical price changes. Smartsheet A: We have production runs of product XYZ listed in a sheet A. Based on a concat we want to lookup a product price based on the MOST RECENT entry from Smartsheet B. However we want to keep Entry A of…
-
Formula Help with Symbols
I'm relatively new to Smartsheet formulas and I'm having trouble with the following formula I've tried creating to control the symbol displayed based on the Status selected for the row. Here's the formula I'm trying with the #UNPARSEABLE error received... =IF(ISBLANK([Status]8), "", IF([Status]8 = 'Ready for Testing',…
-
Populating a Number Value based upon a CONTAINS condition
I am collecting feedback from a series of clients. I am separating each client by their revenue number to show the satisfaction rating for each "tier" of our client base. As such, I am trying to find a formula which will populate their revenue number value associated with their specific client number. For example, client…
-
Importing from Excel to Smartsheet (Grid) using names for contacts
I am trying to import an excel spreadsheet where I have names in a column on each row. The names are formatted as FirstName<sp>LastName, and they are being imported then the cells are being referenced in other SS grids. I would like them to come in (during the import) as SS contacts (name, icon, email shown and can be used…
-
Formula for In Progress and Yellow OR Green health
Hello, I am wanting a formula that shows me all of the "In Progress" items that have a health of either Green or yellow. I can get the formula with just the Green, but not sure how to add the OR "Yellow" part of the formula. =COUNTIFS({Project: VCLC Needs Assessment Range 2}, "In Progress", {Project: VCLC Needs Assessment…
-
Returning Start and End Dates
Hi All, I am trying to get the MIN or start date of a range that only grabs from the row with the same phase. Keep in mind these Start and End dates in the project plan below have dependencies enabled. I would like to return the MIN Start date in the Start Date Metrics column row 3 in image 1. The range is the Actual /…
-
How do I create a report from various forms?
Ok, so I have about 17 forms created for various employees in different departments. Each employee is required to fill out this form x amount of times a month. I want to make a report to auto populate that shows how many times employee filled out the form, and I want the report to show the employees percentage of completed…
-
Automating count formula and trend summary
Hello All, I am wondering if there is a way to automate this process. I am trying to get a count of each line item status type at the end of each day. Currently, I am updating a master sheet that has a status column reading either “active” or “not active.” At the end of each day, I am manually totaling the number of active…
-
Best way to look up multiple values in a multi-select cell?
I have a schedule that contains tasks, and each task has one or more cost codes associated with it. These cost codes are in Dropdown (multi select) cells. For each cost code in a cell, I would like to look up the associated value and add the values together if there are more than one. I am not sure the best way to do this.…