-
Does SmartSheet have an equivalent to Excel's "Name Manager" and "LAMBDA"?
I need a way to label a specific set of data or create a custom function that can be used in cross-worksheet formulas. Related to another query of mine, I need to take a list, give it a specific name, and reference it without having to navigate to the source sheet every time it's needed. For example, let's say I have a…
-
Managing Cross Sheet References at the Workspace Level
Today, cross sheet references must be managed within an individual sheet. I'd like to be able to implement and manage cross sheet references at the workspace level as well. Use Case: 3 sheets containing unique data, but identical columns that are fully replaced weekly; 2 reports generated from those 3 sheets. The 2 reports…
-
Issue with COUNTIFS Formula Referencing Auto Number Column in Smartsheet
I am currently working on implementing duplicate detection logic in our Baseline sheets within Smartsheet. The requirement is to identify duplicate Project Codes and assign a sequential baseline order (1st, 2nd, 3rd, etc.) based on the order in which rows are added. While attempting to implement the logic using a COUNTIFS…
-
Version Control/Backups That Maintain Cell Links
I have seen some posts referencing similar pain points, but thought I would try to distill it into one idea post: Smartsheet is awesome at so many things, but one place where it lags behind other cloud productivity solutions is in its ability to backup, back rev, and implement version control. Yes, you can view history on…
-
Help with functions for attendance tracker
I'm attempting to create an attendance tracker that will add up the total points for a given representative based on the type of 'event' such as No Call No Show, Late Arrival etc. I have a sheet set up that automatically enters the number of points based on the event, calculates any adjusted points and shows points…
-
Copy Single Cell to Cross reference sheet
We’re using a portfolio management tracker. When a dropdown field in the Regulatory column is set to anything other than “N/A,” I want to automatically copy just the Initiative Name, Regulatory Dropdown, and Owner columns to a different sheet in the same workspace. I do not want to copy all columns—only these specific…
-
Unable to Print
I had two nurses call and tell me they are no longer allowed to print their shift report from SmartSheet. Trying to print from the browser leads to a blank print preview page and the below message; there is no print option available on the SmartSheet toolbar.
-
How do I set SmartSheet to include attachments on the emails that it sends from automation?
Has anyone had success in having SmartSheet include attachments on the emails that it sends from workflow you set up? When I create a workflow in SmartSheet to send an alert to someone I want to have the email the user gets include an attachment. Currently my trigger for the workflow is when the data in a certain field…
-
Keep "Sheet Reference Manager" open after creating a new reference: create multiple references
I often setup all of the cross sheet references from the Sheet Reference Manager before addressing any formulas. Currently, the reference manager closes after adding a new reference. If I am adding several references, this means right clicking on the sheet and selecting the reference manager again before creating each…
-
Smartsheet Solution - Dynamic Configurations
We are trying to develop a Smartsheet solution to replace an Excel file that is bursting at the seams and is running slowly due to the number of columns and rows. The existing Excel spreadsheets break down configurations, determining the number of units based on total volume and percentage. The ultimate desired end state…