-
Counting tasks completed on time
I need a formula that says, if the "Complete?" box is checked, was the date in the Actual Completion column on (or before) the date in the Finish column.
-
Update requests-ability to lock down already completed fields
Hi everyone, I actually just realized today that when I have an automation to send an update request and include fields that are already completed, just for clarity, the receiver of the request can actually change the information in those fields. If I am incorrect in this statement, please let me know what I am doing…
-
Control Center is broken
Unable to add new projects
-
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…