-
How to link Task Start and end Dates to another project template file using a formula
I would like to update one task in another project sheet and have it automatically update on another sheet that showcases the more detail project specifics about that installation. I have thought about using the Index and Match formulas, but that would have to hard code the date and the date would be changing.
-
Automation won’t stamp “Last Changed” date when Status is formula + linked cells
Hello! I’m trying to timestamp when the value changes in a Status column I've created, but the Status column is formula-driven and its inputs are linked cells / cross-sheet references from multiple source sheets. In my Master sheet, the Status column is a formula. The fields that drive that formula are not manually edited…
-
Using Forms to trigger the creation of a new Sheet
It would be valuable if Smartsheet Forms could trigger the creation of a new sheet from a predefined template or configurable sheet structure. Use case: standardising project plans In an enterprise environment, we often need to capture mandatory project setup information through a form before work begins. This ensures…
-
Incremental Baselines & Dynamic Baseline Linking
Problem: Current Limitations Destructive Updates: Currently, snapping a baseline is a global action for the entire sheet. There is no way to baseline newly added scope (new tasks) without overwriting and erasing the historical variance data of the existing tasks. Manual Data Entry: Users are forced to manually copy/paste…
-
Exporting Completed Forms
I have created Smartsheet forms for clients. I want to send them their completed form in a readable format annually, to double-check the information they have provided is up to date. The only way I can think to do this is to filter the intake sheet for the client I want, then export to excel. However, this is not a…
-
Merged: Sharing per folder
This discussion has been merged.
-
Introduction
Hi everyone, my name is Anthony Moye, and I am a Project Manager at New Mexico State University. I use Smartsheet to support sponsored projects, grants management, sponsor reporting, and multi-institutional project coordination. I am excited to connect with others using Smartsheet in higher education, research…
-
Formulas and functions for tracking delays
Hello! I would love some guidance on if there are any formulas or functions that are useful for tracking delays with a project. More specifically, our organization is hoping to track who was responsible for the initial and subsequent delays with a project. In our sheet, we have columns for: Task, Assigned To (Dropdown),…
-
Bridging the Gap Between Smartsheet and ServiceNow SPM
The challenge is that when these systems are not connected, teams often spend time manually updating both platforms. That can lead to inconsistent statuses, limited visibility, duplicate effort, and different teams working from different versions of the truth. At Work4Flow, we are exploring this challenge through a…
-
Generate Documents
I am working on a fillable PDF that gives a overview of a project, I need the committee a group of people to pick from a drop down approve, decline, or request meeting and date. Can that we a live document so when everyone answers its all in one sheet? I would like it to generate with the fillable options 1st let me make…