-
Keeping Reference Sheet Formula
Hello, In Smartsheet, I have a metrics file that has formulas to consolidate numbers (sumifs) by referencing a raw data file. The first version of the raw data file was imported from an Excel file, and it has data in thousands of rows. Every 2 weeks, the Excel raw data file will be generated by our system and I will get an…
-
Add special working day exceptions (not non-working days)
Our schedule is typically M-F. But, during special events (Go Lives, etc), we will work weekends. Is there a way to specify specific days which would typically be non-working days as being working days? The only way I can think it to set all 7 days as working days and then specify every single weekend except that one…
-
how to change chart widget axis scales
Hi, I am just wondering if the axis scales values can be changed to fixed values instead of dynamics as it is right now. I would like the vertical axis range values to be set to 0-100% for my below graph: Thanks. Victor
-
Combining multiple views of a project plan in one
In our previous solution, we had five project plans for users to choose from. This caused reporting issues as our milestones did not align between project plans. Has anyone combined project plans into one template and allowed the user to see the appropriate tasks for their chosen project plan by perhaps a filter? Example,…
-
Link or Mirror Rows within the Same Sheet
Hi there, Is there a way to link cells within the same sheet? I want to mirror rows exactly: As an example, I have my sheet divided into 2 workstreams, Finance and HR. They each have their own schedules and deliverables. Since HR Deliverable 1 (line 927) is due between Finance Deliverable 1 (923) and 2 (925) I would like…
-
Formula Tips
Hello! Looking to create a binary number system, due to the fact that dashboard charts must be created with numeric values. Ideally we would have a separate sheet, "the binary copy" and a seperate sheet with all of the original data. For example, if we have yes is entered on the main sheet, a 1 will appear on the binary…
-
Search Window Widget for Dashboard
We have a sheet that contains a list of applications, application manufacturers and will contain the link to where software packages for each package are stored in another program. We're looking for a way to provide a keyword search window where the user could type in the application name or manufacturer and view search…
-
Using Groups once set up
Our team is new to Smartsheets, just getting our sheets set up and ready to share with a broader group. I've created several groups to be able to quickly share content, however, not all of the groups set up appear to be available when I go to share. Any advice on how to troubleshoot so that groups we've created can be used?
-
Dashboards on rows
Hello Everyone, I am trying to build a Dashboard, several teams in my Org. can use. The idea behind this is as follows: There is a separate sheet, which gets filled by using forms / row update. Each Team fills out their row initially by using the form and then does updates on certain fields via a workflow. A Dashboard…
-
Charts
Hi, I can't find a good solution on the below configurations for the formatting of charts with those options available in Excel, is there something I missed? Changing colors of data display (e.g. bars) Changing font size/position of data labels Selecting certain rows in a table for plotting the chart instead of continuous…
