-
Dashboards - Public Access
I want to be able to share a dashboard company-wide that I have created and make it more than "view only". The dashboard contains 3 forms I want any company user to be able to interact with (without me individually sharing it to each user). How do I accomplish this? Currently, publishing it has only allowed users "view…
-
Formula for meeting two criteria and a certain date
I have a Date Column formatted as such [01/01/19 3:59 PM] I have a "Request Type" column which has 3 different request types. (SCHCOM, GSA and OFC MGMT) I need a formula to show how many requests by type by month. How many of each request type came into the sheet in Jan, Feb, Mar. etc..... I tried a few different versions…
-
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…
