-
Calcs for a multiple conditions
Hi, I want to use this formula: =COUNTIFS({1. Main Tracker Range 1}, "Pending", {1. Main Tracker Range 3}, TODAY(-1)) + COUNTIFS({1. Main Tracker Range 1}, "Confirmed", {1. Main Tracker Range 3}, TODAY(-1)) Which has two different conditions, this worked in the Summary tab. When I am referencing it is not coming out. In…
-
Merged: Duplicate Sheet Summary Fields
This discussion has been merged.
-
How to add card and calendar view on Dashboard
Hi there, I want to add a few sheets in card and calendar view on a dashboard. Is this possible? I only see that reports can be added on dashboards, how do we also add sheets. Thank you, Esperanza
-
Sheet Summary Grouping
Allow for grouping content within Sheet Summary window that can expand and collapse.
-
Data Entry Suggestions for Siloing Data for Radar Chart
Hey everyone, I’m exploring the best way to use Smartsheet for collecting score card data and formatting it for a Radar Chart. Ideally, I’d like to: Enter audit results in Smartsheet Modify or structure the data in another sheet Format the combined data for visualization The goal is to merge audit percentages from the…
-
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!…
-
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) +…
-
Merged: Reference Sheet Summary data from another sheet
This discussion has been merged.
-
Merged: Cell Linking And Referencing Sheet Summary Fields From Other Sheet
This discussion has been merged.