-
Cell linking report sheet linking
I have created a set of reports (that selects this project) and an overview/summary sheet that has links into the underlying Project Sheet. We use these set as a template to save an copy to a new workspace or folder for each project. I am hoping there is a way to make the project/sheet links stay within the…
-
Is there a way to Center things on forms
Is there a way I am able to center the headings and information or does it always have to be on the left side of the form. I have attached a copy of the form I am using and now I want to be able to center all the information or move around things on the form to have it linear where an email address and phone number would…
-
Convert decimal back to hh:mm
Hi, Any help would be greatly appreciated. I am trying to calculate the following: Start Work Time (input) First Break Start Time (input) First Break Finish Time (input) Second Break Start Time (input) Second Break Finish Time (input) Third Break Start Time (input) Third Break Finish Time (input) Work Finish Time (input)…
-
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?