-
Aging Date Average
Hi Community, I am attempting to create a KPI for a dashboard that will capture the average number of days a 'something' has been opened, but only if it is still in an opened state. I can perform the appropriate "days open" with "=IF([Closed Count]3 = 1, NETWORKDAYS([Submitted Date]3, [End Date]3), NETWORKDAYS([Submitted…
-
Linking/adding rows using 2 spreadsheets
Hi all, I am having an issue that might be simple to solve, but I can't seem to find an efficient solution. I have 2 spreadsheets: - One with the ID, name, Lot and several other columns with product specification information - Another just with the same ID's, names and Lots, and a few bits more that don't pair with the…
-
Rollup percentage in project schedule template is not calculating correctly
I'm using the project template in smartsheet, in grid view. I've broken my project up in several phases, each phase a parent with child tasks. The Project % complete is coming out as 99% complete, but it is far from being that complete. Is there something I have to do to get this to calculate correctly, or do I have to…
-
Capturing Date of Transaction
Greetings, I would like to capture and freeze the date a drop-down column gets changed to "Picked Up by Customer". I tried modified date but that field gets changed too often to accurately reflect the state. Essentially, I want to know how many widgets were issued by date they were issued without looking at each cell's…
-
Check Box Column Property Not Working
I feel silly asking such a basic question, but it's got me stumped. Normally, under Column Properties, when I select Check Box, a box appears in the column as it should. However, no matter how many times I've tried, no boxes appear. It seems to remain as a Text/Number. Has anyone run into this? Thanks!
-
How to use Forms for populating Sheets
I have bunch of demo units that are used by sales people. I want to use Forms to automatically populate a sheet with a customer name, the desired start date of a demo and the planned end date. Subsequently, I want to use Form to release the use of the demo unit (i.e., make it available for others to use it) as well as…
-
If project status complete - stop calculating formulas & Conditional Formatting
Greetings, Currently at row 1600, waiting for a cell's formula to process the formula may take up to 10 minutes. For instance, sometimes when I change the duration of a Child row by 1 day, it may take 10 minutes for the End Date to advance by 1 day. I use A LOT of formulas, cross-sheet references, as well as Conditional…
-
Filter on columns with values populated by a formula
Hello. After searching and coming up empty handed, I decided to post for help. I have columns in a sheet that are populated by VLOOKUP functions. Whenever I run a filter on one of those columns, all 1703 rows of my sheet are in included or excluded. As an example, if I set a filter on the "Effective Price To" = "is not in…
-
Countif, isdate, weeknumber
Hello, I'm trying to write a formula that will count rows containing a date that is part of the current work week. The date column has non date values in a few cells which seems to be throwing off my formula. This is what I have so far; =Countif([Due Date]:[Due Date], AND(isdate(@cell),…
-
Adding New Rows
Hi, When adding a new row, I cant figure out the rule for indenting. Sometimes it will be correctly indented the same as the row above it. Sometimes it will add new row as a "Parent" and then automatically make everything below it the "Children" Is this caused by the way I'm inserting, or is there a default setting to make…
