-
Status Log Date Push to Dashboard
In a previous, recent question I asked about pushing a text to a dashboard. All the suggested solutions worked. The same scheme did not work for finding the latest date. Seems the code suggested only works for text.
-
Pivot Table using Sheet Summary Report #2
Can I use a summary report as a source for pivot table? I need to include different sheet names as columns and add the products for each one of them. I had a pivot using a summary report and it was working as of yesterday but now is not and I cannot recreate it!!! HELP!
-
How to prevent or recover deletion of rows
Is it possible to prevent the deletion of rows in a sheet? Specifically, in cases where a user legitimately requires editor permission to the underlying sheet and where the row cannot be locked (as continued editting of the row is required.) If not, what are some strategies for recovering a row that has been inadvertently…
-
Attachments in Cells
I rely heavily on Smartsheet’s Document Generation. However, this workflow is currently dependent on having photos stored inside cells, since row attachments alone cannot be used directly in document generation.. If Smartsheet allowed attachments to be displayed as thumbnails in cells (as a reference), document generation…
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Project Management with tracking costs
I am a construction project manager and built sheets that include actual costs for individual tasks, departments and overall project. I update the costs cells as invoices come in by manually calculating then entering in new amount. Ex: Plumbing: week 1 $300, week 2 $250, week 3 $150 = $700. I enter $700 in cell. I'm…
-
Linking sheets - Trying to build off of information from other sheets
Hello! I am pretty new to the intricacies of the platform as I'm looking to lead some project management and automations for the organization I'm in. I have a sheet I am trying to build Automations into, but would like to see if anyone can walk me through how to link this information from other sheets, as they get updated.…
-
Issue with Parent-Child Blueprint Deployment in Smartsheet Control Center
I am working on configuring Parent-Child blueprints using Smartsheet Control Center (SCC) in a multi-workspace setup, I’m encountering an issue with the Parent Blueprint not displaying the parent blueprint as options in the dropdown. The Project Name field selection dropdown shows the Project Title and the associated…
-
Planned vs actual progress (Summary level)
Hi everyone, I am trying to calculate the % Planed based on the start and finished dates but when I try to set the Complete (actual) progress just to verify that all of my plan y on date, I see that the summary tasks are not calculated correctly. I am using the following formula =ROUND(IF(TODAY() < [Baseline Start]@row ,…
-
Limit to number of email addresses added to a sheet for automations
Hello, Can anyone confirm if there is a maximum number of email addresses that can be added as contacts to a particular sheet using automations? I believe that number is 101 addresses. My sheet features multiple approval workflows. Each workflow can have multiple approvers, for which column formulas are used to AND each…