-
Highlight/Calculate Equipment use clashes in a project plan
Hello Community! In the following Project Plan (example), I want to use a column formula or conditional formatting to highlight/calculate when a specific equipment that is used for a task (column named Equipment - currently set to text) is already booked for other tasks/projects at the same period. Ideally, to also return…
-
COUNTIF Checkbox is NOT checked in a cell under a parent row
Hello! I am new to Smartsheet and am having a hard time with a formula for counting in the cell [Action Plan Progress]25 if a checkbox with the parent row 34 under sub row 37 (Checkbox38 to Checkbox41) is NOT checked. I keep getting #UNPARSEABLE Is there a better way or is COUNTIF the right way to go? Thanks!! -Whitney
-
Search in another sheet for a value with sum function?!
Hi community, i have a problem and need your help. I have to sheets "main" and "Input" In "main" I use the formula vlookup to search for a string that is in both "main" and the "input" sheet. if the string is found in "input", I return the value amount to the main sheet. This formular is working without any problems.…
-
How to return the most recent text for a given value?
How can I return the most recent text from a cell, setting a criterion? I tried to use the formula =INDEX(), MATCH() -1, I understood that the "-1" in the formula would return values in descending order, but when I apply the formula the column repeats the same value found in the cell where I applied the formula to the…
-
I want to populate a Quote with information from a price list sheet
Hi Is there a formula or functionality that would enable me to to create a quotation using data from a price list on a separate sheet ? For instance on the price list sheet Column A ( SKU / Stock Code ) , Column B ( Description ) , Column C ( Unit Price ) . I want to fill the SKU / Stock code into the quote and have the…
-
Need to assign an ID between 1-20 but cannot duplicate any numbers.
We have a license sharing system (allowed to share by the user agreement), that we are currently manually assigning IDs that are not in use, but I want to automate the process. Basically, the function should look at the ID column and assign any number between 1-20 that is not currently in the list.
-
SUM multiple values in 1 column when 2 other columns have specific values based on unique ID
Hello! I am not a seasoned user and have been unable to find a solve for my function issue. I have sheet 1 (Request pdf) that is populated by a form. Employees request funds and can have more than 1 entry. On sheet 2 (allocation pdf), each employee has a set number of funds available. I want to add all of the $ requested…
-
Is there a way to copy certain cells from one SS to another without creating new row?
I have a project that I am managing in SS. The customer also has the same project they are managing in SS (their own domain). I have admin rights to both, but my admin rights in theirs is assigned to my gmail, whereas my sheet is assigned to my company email address. They need to see only certain information from my sheet,…
-
Average values assigned from health ball forumulas
We need to average 4 columns that utilize Harvey balls to determine an overall project score. We added helper columns with a column formula that would assign a value to each rated criteria (budget, time, scope, quality): =IF(Budget@row = "Blue", "5", IF(Budget@row = "Green", "4", IF(Budget@row = "Yellow", "3"))) Is there a…
-
using a COUNTIFS formula and @row
Hello I have a cross sheet formula grid, where i am trying to count multiple ranges and multiple criteria. My formula is =COUNTIFS({Group}, "Playout", Show@row, {Action}, "All Call") and I get an Incorrect Argument Set error The 'Show@row' piece is meant to not have to do individual formulas for over 130 shows. I'd like to…