-
Product Selection using Contacts
Hi Just thinking aloud... is there any reason why I couldn't import my product inventory into 'contacts' and use the 'contacts' feature as 'products' and be able to select multiple products in one cell on a row? And then do counts of products within a sheet or a selection of rows? Thanks Cheers Richard
-
COUNTIFS for Projects Completed Within Past 90 Days
For some reason I can't get this formula to work. I get 0 every time. Using a filter, I can see that number is incorrect. I want to count how many "Course" projects, per organization have hit complete in the past 90 days. =COUNTIFS({Project Type}, "Course", {Organization}, Metric@row, {Completed Date}, <=TODAY(-90))
-
Data Matrix for dashboard - cross sheet formulas
I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading: "Some cross-sheet formulas cant be updated, because this sheet has more cells referenced from…
-
Multiply across columns, then sum children
I would like to use the sum children formula, however the calculation includes other columns before it can sum. The month column contains number of units, while the cost of each unit is in another column. The sum for the month = #units * cost per unit. Can the children formula be used so that the formula doesn't have to be…
-
Formula Woes
My old formula: =COUNTIFS({Implementation Rollup Type}, OR(FIND("new", LOWER(@cell)) > 0, FIND("exist", LOWER(@cell)) > 0), @{Implementation Rollup Work Start}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) <= [1/7/19]$1, {Implementation Rollup Work Finish}, IFERROR(WEEKNUMBER(@cell), [1/7/19]$1) >= [1/7/19]$1, {Implementation…
-
Search Projects as Per RYG status
Hi, I looking for solution or moreover a formula to get a project name back as per RYG status. But i am getting problem, i have a same RYG for more then one projects. For example: i want a list of projects As RYG "RED", the selection has to show me 2 projects in retuen Project 1 Red Project 2 Green Project 3 Yellow Project…
-
Checking if a cell has absolutely nothing in it
I have a sheet where I have needed to suppress any errors with ISERROR function. The formulas are showing blank now because division by zero errors are suppressed. The formulas will show data when data is entered in other cells. The issue is when someone adds a row to the sheet, I want to make it apparent that they forgot…
-
How t set a default value to Symbol column
Hello! I have a symbol column with 3 options representing payment status, (Yes, No, Hold). By default it should be "Hold" until the user choses if the payment was accepted or rejected, so what I would like is that whenever a new row is filled, the symbol cell should be set to "Hold" by default. I know formulas don't work…
-
Auto Number: possible to generate Project IDs in Smartsheet?
Hello. Is it possible to generate Project IDs in Smartsheet ? And can these be done using the Auto-Numbers feature ? I have a master sheet containing a list of all the projects that have been under taken in a specific year. I need to assign Project IDs for each project. Can one generate auto numbers for specific rows ? As…
-
CountIf with Date range
I am trying to count the number of requests types between a date range. This is what I thought would work: =COUNTIF(({Request Tracker Range 4 - Request Type}, Category5), AND({Request Tracker Range 3 - Date Requested}, DATE(2019, 01, 02:2019, 03, 14))) I am using this formula to count the entire column =COUNTIF(({Request…