-
Options to display all formulas/functions in a sheet
Hi Community, I am a new user and would like to know if there is a way to view the formulas/functions within a sheet either as an ad hoc toggle on/off feature/shortcut or by leveraging the report builder. I understand that we could copy the formula/function body as text to a hidden column for reference or reporting.…
-
Impossible to set a Date Constraint (Blue Anchor) - Predecessor is being deleted instead
Hello,I'm struggling with date constraints on child rows. Setup: Dependencies are Enabled. I have a standard Parent/Child hierarchy. I want a child row to have a Predecessor but also a "Start no earlier than" date (manual constraint). The Issue: Every time I manually enter a Start Date on a child row that already has a…
-
Error message when opening my project : Une erreur est survenue dans SmartSheet
when i try to pen my project, the message below appear, i don't know what to do. My collegue has the same issue. I tryed on another browser, or computer. it was the same
-
Resource Management Calculation
Summary of Issue All team members work a standard 7.5‑hour day, but only a portion of that day is allocated for project work (e.g., 25%, 50%, etc.). In Resource Management, however, the system currently interprets allocations as a percentage of the full 7.5 hours, instead of the project‑eligible portion of a person’s day.…
-
How to recover deleted calendar from Calendar App?
My colleague accidentally deleted a calendar I created in the Calendar App that our team shares. How can I recover this? It's not in our deleted items. I do have the URL, currently seeing this error: Oops! The page you were looking for doesn't exist. (ErrorCode: 404)
-
Global/Regional Holidays feature
Dear Smartsheet Product Team, We would like to request enhancement to Resource Management (RM) to improve its functionality for global teams: Country-Specific Holidays Currently, any holiday added in RM applies to all resources company-wide, with no option to assign holidays to specific countries or groups. This limitation…
-
Adding a new Column to multiple workbooks
I have used the same template to create a tracking system throughout our company and now have 25 sheets. I have been asked to add a column to the template and all existing workbooks. Does this need to be done manually one at a time?
-
Sum Collect or If Statements
I’m trying to build a formula that can achieve the following logic, but I’m struggling to get it working correctly. I have a data sheet with around 100 project rows. Each row contains a Fab Start date and a Fab Finish date (along with many other fields). Some projects run across two consecutive months. In my metrics sheet,…
-
Project Attachments Need to be on dashboard via SCC
I am using SCC to auto provision projects. One of the asks is to have project specific documents be in the project specific dashboard, these documents arent made available until after the project provision. Currently since i am the Smartsheet person, i am sent that data and need to do this manually, however I want them to…
-
Smartsheet Admin Analytics & Governance Automation
Over the past few weeks, I’ve been building an internal Admin Governance & Automation Framework for our Smartsheet environment — focused on visibility, auditability, and operational efficiency. Manual tracking simply doesn’t scale. So, I designed and implemented a modular, API-driven crawler framework that programmatically…