-
CELL LINKING TO FORMULA
I have linked a cell in a template sheet to the same cell in the various iterations of the template but unable to then convert the formula in each sheet to Column Formula. Could this be considered as it could save a lot of time if a formula needs changed for any reason as updating the template would automatically update…
-
Cell Links not being Created as Designed in Blueprint in Control Center
I am having an issue where I am in a new Program and when I create a new project (automation set up to create a project based on the type of project entered into the intake form), the fields I have selected to create cell links in the Summary Section of the Task List isn't creating the links from the Intake form to the…
-
Using App to Schedule Resource
I am using Smartsheet to create a calendar system for reservation of a shared resource. So far, I have not been able to find a way to add TIMES to Smartsheet so more than one person can schedule the same resource on the same day, during different time slots. Can you help? Furthermore, these resources are occasionally…
-
Link sheet to rotating cell in feeder sheet
My team is trying to create a "wrap up" type sheet that pulls data from child sheets that are updated monthly from a form. The data in the child sheets that needs pulled are the most recent submissions from forms associated with the child sheets which means the cell will constantly change. Is there a way to link these…
-
Linking checkboxes across 2 sheets
I've got 2 spreadsheets for tracking job progress. One is an end of day report filled out by field personnel. The other is a collection of all the information about various jobs gathered from the end of day reports and manually entered data. I want to link a checkbox when any end of day report has a "Install complete"…
-
Need some help with a health formula for task risk level analysis
Hello, I am currently working on a formula for the health column in my smartsheet that is based on the the task status and the end date of that particular task. This is what I have so far but what I need is for when the "end date" cell is blank I would like for the health of that task to be blue. The reason is we do not…
-
Copy/Paste Cell linking
I am trying to use the paste special option to link a cell but the "Links to copied cells" radio button is grayed out. I've tried this on multiple sheets, and it still will not give me the option.
-
Adding email list for Automations
Hi All, I have a Drawings Sheet that I use to update contractors with up to date drawings, I send them a simple published URL but do not share the sheet with them. (See below) I use another Project Sheet to run the project and keep a status of the jobs. In this lists all the contractors with a Purchase Order for the works…
-
Maximum number of cross-sheet references per sheet
Dear Smartsheet, Please tell me that the below error is just a soft cap like the 5,000 cell-link limit. I probably have 100 unique cross-sheet references in a metadata sheet I've been putting together. I am about 90% of the way through and just encountered the below. The way my sheet has been structured makes it impossible…
-
How can I link two sheets together?
Hi. I am a communications and brand manager, and I have two sheets that I will be working from primarily. One is a Request Form, the other is a Master Calendar. These need to be different because the Master Calendar includes things such as company events to which I need to send a photographer for internal communications,…
