-
Inserting a Formula into an existing Equation
I have a simple math equation in one of my cells, and in place of one of the numbers I would like to reference a count of cells with dates in them in a certain column. My equation is: =100 - (((60 / 477) * 100)) (this returns a number in a percentage format) and I would like to replace the number "60" with…
-
Calendar View
New to Smartsheets but I've created individual project sheets and I've taken key production data, specifically dates and linked them to a Master Production Schedule sheet. I've added the customer name as the parent and each stage of production as a child which allows me to see customer names and all of the steps in…
-
Print multiple selected rows with all comments printing below each
I would like to hardcopy archive selected rows from 2017 but would like to select a group of rows and print one row then comments, then repeat for each row. Do this for many rows at a time. Any thoughts?
-
Making a Date Column N/A unless needed to for a specific row
I was wondering if there is a way to make a date column go N/A unless needed for a specific row or rows. For Example: I only want the Delivery Date Column to be active when it comes to Deliveries. Is there a way to do this or no? Please Help Thank You.
-
Portfolio Reporting
I am new to Smartsheet and my goal is to have a dashboard for our PMO with links to the various projects. Each project may be led by different people in the company. Do you have suggestions on how to set up the Dashboard for automatic roll up of information? I have found some helpful articles here, but I would love to know…
-
Dashboard metric widget - size of the status RYG ball
I successfully created a dashboard with a widget that displays an overall project status from a sheet. I can manipulate the title of the widget to reflect this is a key metric but the status ball doesn't appear to be sizable and looks tiny compared to my title. Is there a way to increase the size of the ball to match the…
-
Alerts and Actions Badge Number
With the new UI change I am sorely missing the Alerts and Actions badge number that told me how many alerts and actions are attached to each sheet. What are the possibilities of including that number in the menu next to the menu item as in my attached screenshot?
-
Search or Filter to find entries based on the link instead of the value in a cell.
Hello, I'm relatively new to Smartsheet and have inherited a complex network of sheets that reference other sheets. Unfortunately there are a lot of entries where come of the cells are properly linked but others are not and it wold be very helpful to write a report or come up with a filter that can tell me which of these…
-
Smartsheet/JIRA Connector: Putting tickets into their sprints instead of in the backlog
We have set up a connection between Smartsheet and JIRA and whenever a row on our Smartsheet becomes a ticket in JIRA, it automatically populates in the backlog instead of within the sprint we've defined within Smartsheet. Is there a way to get around this? I saw a thread that I think was related to this which mentioned…
-
COUNTIFS returning #INCORRECT ARGUMENT SET
Hi all - I cannot figure out what's going wrong here. I'm trying to count rows in another sheet ("Sheet A") where both the following are true: * Done = 0 * IsChild = 0 My formula is: * =COUNTIFS({Sheet A Range 2}, 0, {Sheet A Range 4}, 0) Now this works perfectly! So in a cell right below that one, I then try to count rows…
