-
October 2025 Badge
Hi all, Who can I contact about getting my October 2025 Badge? I did post. I appreciate your help. Happy Monday!
-
Ways to avoid 25000000 formula cell reference limit
We have a sheet that we use for time tracking for some of our projects. We have about a dozen people supporting projects and they may log their time multiple times a day. I have a SUMIFS formula that adds the duration for each client project. Formula: =SUMIFS(Duration:Duration, [Client ID]:[Client ID], [Client ID]@row ) I…
-
Is it possible to add a document control revision number to my sheet somewhere besides the title?
I want to use smartsheet for some of our day to day needs, but I will need the smartsheet to be considered a controlled document for ISO. Where in smartsheet can I add a document number, revision letter, and date? It is cumbersome trying to fit all of that in the title of the sheet, any properties, headers/footers that…
-
Ability to filter gone for non paid users?
I am running a large-scale deployment project and today my unpaid users are no longer able to a column and filter on their name? Says you have to have a paid account to filter?
-
Have Header Row Sum All Items Within Same Column
I've been trying a few different things to see if I can get this to work and unfortunately I'm having a hard time. Right now, I have a resourcing sheet that has header rows for each team member and each week has it's own column. Every task needs to have the number of hours entered per week for the work effort. Because of…
-
Summary sheet values don't update in dashboard without entering source sheet?
I have a sheet summary report on a dashboard and oftentimes the values will not update unless I go into the source sheet and manually save the updates. For example, the WEEK TIME OFF value often will not update week-to-week unless I go into that contact's sheet and save. I have tried adding a daily Chron automation…
-
Data Shuttle does not import times from excel correctly
Hello, We have an excel sheet that has a Start time and stop time for tracking how long items took. However, when we use the Data Shuttle, SmartSheet converts the time to a date. How can we keep this in a Time format ( 8:00 am)? This is a critical part of our playbook with clients, and we need Smartsheet to be able to…
-
Why do I get #invalid value?
Hi everyone! I am using this formula in the Date column to pull a date if 2 criteria are met (name of the client and the specific module): =INDEX({Date}, MATCH([Column11]3, {Client}, 0), MATCH([Column4]@row, {Module}, 0)) It works in the "Module 1" row, but not below, any idea why? Thanks!
-
With Dynamic View, how to track viewers
I have a use case where Dynamic View must be used. And the user base cannot be given permission to the entire underlying sheet. But we also need to somehow track who is viewing the sheet. Bonus if we also can determine how often. Can anyone think of a clever way (maybe by putting some helper columns in the sheet) to track…
-
Auto Create Child Rows from Dropdown; how to get array values to auto populate each child row
Hello :) I am building a project management system where we have: Asset (Parent Object) Components needing fixing/replacement (Child Objects). In my Bridge workflow I have managed to achieve child row creation based on the number of values in the dropdown cell (components). I need to add a feature that spreads each…