-
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…
-
Report Building with Dashboard Publishing
I have started developing a report. Is it necessary to create the data sheet (which will drive the report) in a seperate smartsheet from where all my entries are or is it OK to build the data on the same smartsheet by adding columns and then hiding ?
-
One column to read multiple if/and criteria and populate
O.K., I have a detailed question so please bear with me: I currently have the following formula that works at the moment: =IF(AND(ISTEXT([OPEN ISSUES]11), [STATUS 3]11 = "Closed"), "", IF(AND(ISTEXT([OPEN ISSUES]11), [STATUS 3]11 = "Open"), "Open Issue", IF(AND(ISTEXT([OPEN ISSUES]11), [STATUS 3]11 = "Pending"), "Open…
-
Integrate with Microsoft Planner
Is there any possibility of Smartsheet integrating with Microsoft Planner? Smartsheet is equipment to manage full portfolio where Microsoft Planner seem to only focus on individual projects. I am a seasoned Project Manager and I need to see all projects at a high level view. Several departments within my organization uses…
-
Formula
Hello everyone, I'm new to smartsheets and so far my experience has been positive but I'm heading into areas that go beyond what I have learned so far, I used basic formulas to do counts using =SUM, and =COUNTIF but I only have been able to use it to do basic counts. I need a formula that will look at at multiple columns…
-
Comments
How many characters are allowed per comment?
-
SUMIF problem - "#incorrect argument set"
Hello, I am getting the "# INCORRECT ARGUMENT SET" error when using the following formula: "=SUMIF({Treads Extruded 2019}, MAX({Week no.}) = [Current wk no.]1, {Production Qty})" I have attached an image of the table I am working with, removed any sensitive information. I want to add all of the production quantity up for…
-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…
-
Sheet automatically scrolling across as soon as I place mouse in sheet.
I have one sheet (that is shared) that automatically scrolls across to the right of the screen as soon as I place my mouse in it. I can not manually correct it back to centre or to the left of teh screen so i can read the data in it. My other sheets are not affected, and are working fine. Can you please recomend a remiedy.
-
Date miss matching
Hi all, Ok so I reside and work for a company based in Bangladesh and we use this format for date ( Date / Month / Year ) so today will be 30/3/2019 I have two base sheet that feeds directly to a master sheet via direct cell linking which is used by the management to keep track of the latest updated. Now the base sheet the…