-
Need Help with Multiple Criteria
I need a formula that looks for the a specific person in the Ball In Court column, then look at specific status in the Comment Status column and then look at another column and if it is blank return the number. I am not sure on what this should look like for the last column.
-
Min Collect Help - date returning zero value
Hello, I am looking for formula help where I want to return the earliest date in a range for different workstreams groups on a project. The source sheet is formatted as a date field, and the formula used below is returning a 0 no matter what I do. Any suggestions? =MIN(COLLECT({Project Plan - start date}, {Project Plan…
-
Displaying multiple time periods in Gantt view
Is there a way to display multiple time periods in Gantt view? Example: you have staff members that are your primary people, and they are contracted for 4 months, and then secondary or "fill" staff members that sit in when the primary is away on sabbatical or similar break. Idea here is that the gantt bar on a given row…
-
Authenticator app MFA for non-SSO login - now generally available!
October 30, 2025 Smartsheet users can now secure their accounts with authenticator-app multi-factor authentication (MFA), available at no additional cost for all plan types. With this update, users who sign in without SSO can verify their identity using trusted authenticator apps such as Microsoft or Google Authenticator —…
-
Rows disappear while editing my sheet.
My colleague have been working on a sheet for the last hour+ and while some changes have saved She is saving every couple of minutes) loads of my changes have disappeared. Do you have any idea why? more info: Editing - directly into the card view. Rows disappearing immediately after saving - No. I'd been making changes for…
-
I Can't Get Bridge's match function to match anything
I feel like what I'm trying to do is simple but nothing is working. I'm following this help article: Copy partial rows to another sheet using a Bridge workflow | Smartsheet Learning Center What I want to do: When the column titled "Trigger Workflow" is changed to "Yes" It runs. It checks to make sure that the value is…
-
How do I change the default sheets that open on the desktop app?
I am using the desktop app and notice that the same 4 sheets are opening up when I start the app. I would like to change this as the ones that are opening up appear to be the same 4 I was looking at the first time I used the desktop app. There doesn't appear to be any setting to or feature to set the initial sheets (a la…
-
Distinct values from multiple sheets
I currently have 14 sheets with the following columns: Batch # and Reviewer I use an Index Distinct formula to acquire the unique batch numbers from all 14 sheets and put them into 14 columns on the 'metrics' sheet. I then use another index distinct to get a list of all the unique batch numbers into one 'Unique Batch…
-
Welcome to the online Smartsheet Community!
https://youtu.be/NLinzZb6iwk?si=_hi2DROZxmP8bdnE This is YOUR space to connect with people around the world who are driving achievement at work with Smartsheet. We’re so excited you’re here! (Learn about the supportive and helpful culture of our community by reviewing Community Guidelines or take a look at our full site…
-
Returning matches in Multi-Select column for exact match of value and excluding "Value" + "Text"
I am seeing if I find a match for a value in a multi select column and using the HAS formula. It is returning when the string is found, but also when a string plus additional words is found. For example I am looking for if the color "red" has been selected in the column, but it is also pulling in when "Red Rose" has been…