-
Help with Form creation
Hi, I am trying to create a smartsheet form that would help me to outfit rooms inside a building with the appropriate gear. I created 2 sheets with the following headers (columns) Sheet #1 : two types of headers 1st type: 6 fields already populated Column 1: Item Identification # (Primary column) Column 2: Item description…
-
Conditional Format Checkmark
Hello, I am trying to add conditional formatting to my smartsheet that will checkmark the checkbox column (duplicate TCIN) if there is a duplicate in "TCIN" column. Please help. I tried adding a help column to identify duplicate with countif formula, then tied the checkbox column to the duplicate, however cannot get the…
-
Workflow not functioning
I was able to select my destination sheet and now I am unable to do so. It doesn't even populate anything to select. Anyone else encountering this? Did I forget to do something specific?
-
Symbols Formula
Hi all! I am trying to set a IF forumula for symbols changing colors driven by multiple columns. =IF([BYT RELEASE DATE]@row = 0, "Red", IF([BYT ORDERED]@row = 1, "Yellow", IF([OPEN ISSUES]@row = 1, "Blue", IF(RECEIVED@row = 1, "Green")))) I can not seem to get the right syntex. Help is appreciated ☺
-
Dynamic View Safe Sharing now generally available!
Hi Community, In support of enterprise security, we are integrating Dynamic View with Smartsheet Safe Sharing capabilities to ensure Dynamic Views can only be shared to users and domains that are approved by the customer’s Safe Sharing list. Admins now have added assurance that views are only being shared with trusted…
-
Dynamically choose what column to sum if in another sheet
I am trying to build out a scheduling tool for my team. On one sheet (source), they can add all the jobs/staffing/hours. The other sheet (total) I want to sum total hours by week for each team member. I could create a Sum Collect and do a separate range for each week. However, I have the week # on both sheet, so am hoping…
-
Export My Smartsheet Contacts
When I select this option, nothing seems to happen and there is no .csv file in my downloads folder. Any suggestions?
-
SUMIFS Formula/Cross-Sheet Reference
Hi, I'm trying to calculate weekly hours worked per consultant in sheet that references our master project tracker sheet (each consultant has multiple projects, one per row). In the master tracker, one column has the names of the consultants (titled Consultant), one column has the project status (titled Engagement Status),…
-
Report Filters Not Responsive
I've created a helper column in my sheet for parent/child relationships, which assigns it a number based on this formula: =COUNT(ANCESTORS([SOW Item or Task]@row)) + IF(COUNT(CHILDREN([SOW Item or Task]@row)) > 0, "+", "") In my report, I've created a filter to allow for all numbers except 1+: However, the report is not…
-
Looking to tie two columns together.. see below
Hello, I have one column that has a list of 'epics' (main categories) in the next column I have a list of all features. I need to somehow group a subset of the features to an 'epic' when the epic is chosen the user will only see the subset of features for that epic. How can I easily do this? Example provided in attached…
-
Cop row automation target sheet dropdown field does not populate from source sheet
I am using automation to copy a row from one sheet to another. The source sheet has a dropdown Assigned to contact list field. The target sheet has the same Assigned to contact list field. The selection from the source sheet does not copy to the target sheet. How can I make this work? Thanks for your help!
-
Add attachment Icon to child card in Board View
Problem: Board view doesn't show attachment indicators at the child-card level. Proposed solution: Show a paper clip on cards when there is an attachment. Thanks, Marc
-
Autosave Form Edits, or Warn About Leaving Page
My biggest gripe with SmartSheet (I am forced to use it by my company) has to be the autosave feature. That it is not active by default is egregious, and the fact that it's a personal setting per user makes it difficult to quality control. Beyond that, I learned today that the form editor does NOT autosave as you work, and…
-
Edit / Removal of 'My Smartsheet Contacts"
I'm logged in as the owner / admin of my personal account and every attempt I make to delete or edit a contact fails. What is wrong?
-
Chart Colors Change to Red and Blue
I have two donut charts set up in a dashboard, one is older and the colors are green and grey. I want to set the 2026 version to match, but when I change the colors and select save, they change back to blue and red. Any ideas? I noticed that the series are "unnamed" on the 2026, and are "true" and "false" on the 2025…
-
How to apply a conditional formatting at a cell value level
Good morning, Working with the team to build a dispatch list for our shop to work to building engines. Each engine has multiple modules that must be completed first in order to complete the entire engine. So an ouput board has been created with the columns representing the modules and each row representing an engine. The…
-
Error #BLOCKED
Buen día, se me está presentando el siguiente error en una de mis hojas. Actualmente en la hoja hay 2890 filas con alrededor de 90 columnas (la gran mayoría formuladas). Al intentar mudar filas a otra hoja para depurar la memoria sigue permaneciendo el error y las celdas aparecen "#BLOCKED". También, ya intenté quitar…
-
Workflow owner has been deleted
We had a user who ran our Salesforce Integration between SmartSheets and Salesforce. He had exited the company and the team over SmartSheets deleted his user. You can 'see' the workflows that were in his name that now say "missing owner". Is there any way to reassign? If we have to recreate the workflow is there any way we…
-
User changing to another plan
We have a group account and a user is going to a different account. They want to use there current email. How to remove them from my account and they can keep there data?
-
Assign to Account Manager when status changes
I am trying to create a workflow so that when a Status changes to 'Available in Partner Album,' the person listed in the 'Account Manager' field is automatically assigned to the task in the 'Assigned To' column. When I create the workflow, it asks me to select a specific person, but I want it to pull whoever is listed in…