-
Giving an output based on text from multiple selection dropdown
Good Afternoon, I've been racking my brain trying to get this function to work. I have a column set up to allow multiple selections of specific text with the column name "Processes." I want the cell to find the specific text and give a number value. I'll then pull from a "Due Date" column giving the processes start dateโฆ
-
Help with getting data out of a sheet into a sheet that feeds Dashboard
I have a main worksheet (1) I have a secondary worksheet (2) that pulls data from (1) and calculates values. Worksheet (2) feeds into Dashboard I have successfully managed to pull across column total values/volumes and also managed to separate these out by sales person I'm trying to do the same with sales Value (column) byโฆ
-
How to use IF and IFERROR?
I am writting the formula for counting the result of the work of my team. The result is counting from the complete date< expected date would be green and if it is greater, it would be red. However, in some cases, even i did not fill in the expected date and completed date, but the result is still showed as green. Thisโฆ
-
Generating an "if greater than zero, then this" "if less than zero, then that" formula
Below is the formula that I'm trying to use. =IF([Days Behind]@row <=0,โ$0.00โ, [Days Behind]@row >0, [Days Behind]@row * 257 Essentially I want the cell to read as "0.00" if the days behind column is 0 or below. If the days behind column is 1 or above I would like it to read as the formula [Days Behind]@row * 257 Thankโฆ
-
How do I create an if blank then this and if populated then that statement?
Hello! Below is my current formula for a column to calculate days behind. =[Planned Start Date]@row - TODAY() The problem is we want this sheet to be accurate without having to have cells have different formulas. What I would like it to calculate is IF [Actual Start Date]@row is populated, then [Planned Start Date]@row -โฆ
-
Nested If Or IsBlank + If Statement
I'm trying to write a formula for the following: 1 -If GO FW is blank then "shop closed" 2 - If GO Date is different than Original GO Date then "shop open date change" If neither 1 or 2 then nothing
-
Formula to count number of items if it matches both headings.
Hello, I am currently stuck on this formula. I'm not sure what I'm doing wrong but the formula keeps on providing a return of "1" for everything, when I know I have "2" counts of items which are under category 1 and have a status of in progress. =COUNT(COLLECT({Status}, $Label@row, {Project Category}, [Category 1]$1)) Anyโฆ
-
How to compare rows within same Smart Sheet
I need to compare rows that have a duplicate key found in the Row # column (see blue highlight). Once matched, I need to further compare the Prev Row Submission Date to the Date column in the matching row (see yellow highlight). Once the match is identified, I need to compare the CIN Count (Total) most recent row entry toโฆ
-
Live clock / stopwatch function for dashboard
Hi all, We're looking to migrate a production performance tracking tool from Excel into Smartsheet so we can leverage connections to other datapoints we have stored there. Intent: One of the functions this Excel is serving (via VBA) is to provide a live clock function with seconds to show time elapsed between a 'start'โฆ
-
Sumif Issue Multiple Criteria
Hello, I am trying to sum the number in the Count column (Range 6) if the solution = RC WHS (Range 4) and if the 1st Inbound in the 2nd quarter of 2023 (Range 5). This is not working. =SUMIFS({1. Task Sheet Range 6}, {1. Task Sheet Range 4}, "RC WHS", {1. Task Sheet Range 5}, "1st Inbound", {1. Task Sheet Range 5},โฆ