-
How do I create a summary line in a schedule that shows the earliest start date and last end date?
I'm looking for a way to make the first row of a project schedule show the earliest start date and last end date without having to make all rows under #1 subordinate to row #1. This is just a pet peeve that in order to have one row in a schedule display the earliest start, total duration and last end date, I have to make…
-
Sheet Summary Formula Help
Hello, I am trying to pull some numbers from a list of past projects that have completed from certain years. The formula i have will pull from the current year. I need to know how to pull from 2024 and then in the future I will pull from 2025, etc. I have tried changing some parts, but it will not work. Thanks!…
-
Formatting report data coming from Sheet Summaries
Hi, I have created a Sheet Summary Report which pulls data from the Summary tab of multiple source sheets. Nothing easier, right?? But, I can't see any way to center-justify the data in the report (because normally it grabs the justification from the source sheet column). Is there a command somewhere I'm just not seeing?…
-
COUNTIF Formula for Checkbox Column Not Working in Sheet Summary
I'm trying to create a formula in the Sheet Summary that shows the number of checked items in a Checkbox column named Pending, out of the total number of rows that have either a checked or unchecked box (i.e., excluding blanks). =COUNTIF([Pending]:[Pending], 1) + "/" + (COUNTIF([Pending]:[Pending], 1) +…
-
Enable Cross Sheet References to work with Sheet Summary
I check with Smartsheet to see if this was possible and it is not. I've submitted an enhancement request. Support suggested I post the idea to the Community so folks could "like/vote for" the idea. If by chance someone knows how to do this...reference sheet summary values from another grid, or between sheet summaries on…
-
Merged: Built-In Sheet Health Metrics: Help Us Monitor Limits Before They Break Us
This discussion has been merged.
-
Possible to send MS Outlook email Templates once a task is reached
I am trying to set up outbound emails to send to external parties for their deliverables, setting timelines, and forms to complete once certain milestones/tasks are reached with in a project. Is it possible to have a email template built / added and have that template pull in information from the sheet summary such as…
-
Metric Widget without Summary Sheet Report?
I'm trying to figure out a formula-free way to show summarized info. 😅 I have 3 Cities on my Sheet; each city has 'co-parent' rows, and under these co-parent rows are Tasks that have a Status. I'd like to have a Metric widget on my dashboard that shows the number of Tasks per Status, per City - for example, 'Tulsa' In…
-
How Do You Document a Log of Notifications of Sheet Changes
One complaint that I am getting back from shared users of a sheet is that many times they don't know when something has changed. I can certainly make this manual task outside of the Smartsheet but I'd really like it to be captured in the sheet. For instance, I could use "File --> Email Shared Users" as the method to create…
-
How to Automatically Update Rows in Smartsheet Based on Another Sheet?
I’m working with multiple linked sheets in Smartsheet and need certain rows to update automatically when data changes in a source sheet. I’ve tried using cell linking, but it's manual and not scalable. Is there a way to automate this using formulas or workflows within Smartsheet? Would love to know how others handle this…