-
Writing Formula for Sheet Summary Field
Based on the screenshot below, I am trying to write a formula that will pull in the reason for change on the row where " most recent change" is checked. Thoughts on the best formula? I've tried: =IF([Most Recent Change]:[Most Recent Change] = 1, [Reason for Change]:[Reason for Change] , "") Is there something I can do with…
-
Unparsable formula; Sheet summary SUMIF formula
Can anyone help why this formula is coming up as unparseable? I'm creating a sheet summary, where it totals the Estimated GP (Est. GP) column if the Status column has the "Quoted" drop-down option is selected. Formula i've used: =SUMIF(Status:Status,"Quoted",Est. GP:Est. GP) Thanks a lot!
-
SUMIFS with wildcard (*)
Hello, I am trying to use the sumifs formula for summing values in one column based on the first two letters in another column. This formula is not working =SUMIFS([Total Invoiced]:[Total Invoiced], [Google Location ID]:[Google Location ID], "CA*") I have tried exchanging the criteria column at the beginning as well, and…
-
Sheet Summary Formula capturing dates before current expiry date column
Hi all, I thought I had this one down but I keep getting an error message. This is a sheet summary formula. Any ideas what I am doing wrong? =COUNTIF([CURRENT EXPIRY]:[CURRENT EXPIRY], >TODAY) Thank you!
-
Metrics Pulling Help
Hi there! I have a submission sheet and a metrics sheet. I am attempting to create a formula on the metrics sheet pulling from the submission sheet. I have no trouble pulling counts, but averages are giving me some trouble.. I am able to pull the average based on 1 criteria, but no more than that. I am looking to average…
-
Row-wise Reports of Sheet Summary data
Hi It would look much more elegant if the sheet summary cells in Smartsheet reports could be displayed in a row-by-row format, rather than just the current column-only layout. I feel this vertical arrangement, as shown in the attached sample image, would create a cleaner and more appealing presentation.
-
Formula in Sheet Summary returns different count result than filter
I am trying to count new entries in a list added during the previous week. If I filter data on "Create Date" between the dates for Sun-Sat last week (eg 8/3/2025 and 8/9/2025) I get result A (65). In my sheet summary I used this formula: =COUNTIF([Create Date]:[Create Date], IFERROR(WEEKNUMBER(@cell ), 0) =…
-
Can a form be combined with a sheet summary report?
I need to combine a sheet summary report of existing data with a form that can capture and record new, incoming data. I've done both separately, but need to know if this is possible in one sheet.
-
Countifs between 2 dates with status
Within Sheet Summary I can't get this formula to work, it keeps saying invalid value. Any help would be greatly appreciated. I am attempting to create a dashboard for items I have being completed on time or not using "0" or "1" through other formulas within the sheet. For example, looking for the number of CPAs completed…
-
Countifs for cells containing a letter
Hello, I have a formula to count how many hours of work I have assigned to me in a given week. It has the following inputs: "Owner" and "1st day of week" and it looks in a different sheet for all rows that meet that criteria and returns the estimated hours for the tasks. My formula is below and I want a solution for the…
-
Summary Sheet & Filter based on Form Responses with Multi-Select Dropdown
Hi all! Hoping for some assistance with a summary formula pulling in criteria from a multi-select dropdown response form... I have a dashboard that has a form embedded in it to allow the user to enter their desired criteria (see below screenshot) and then the bottom of the dashboard pulls in the metrics using the form…
-
Date format changing
I have several Project Status Sheets linking to an overall programme Dashboard. Although each Project Status sheet has the correct UK date format, when feeding through to the programme status sheet and the dashboard, it converts the date format to non UK. This causes issues when looking at the status sheet in Calendar…
-
Summary Sheet Formula - conditions
Hi Wizards, I use a lot of formula including summary sheet formula for use in dashboards. SUMIF and CountIF are great but here is my problem (bear with the long explanation) 3 departments fill in a daily form and select Area (Stoke, CC or Transport) and then provide 4 or 5 pieces of information all through a form. This…
-
Why does the Sheet Summary SUMIFs formula show a different result than my report?
I am using this formula to report the total $ amount of past due projects, which rolls up to a dashboard for our team. =SUMIFS(Fee:Fee, [Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "1-Pre FMV Info Request") + COUNTIFS([Key Deadline]:[Key Deadline], <=TODAY(), Status:Status, "2-FMV In Process") + COUNTIFS([Key…
-
How do I get my datasheet to show the months requests were opened and closed
when my request tracker sheet's input is in calendar format? Current set up is as below, and I'd only like to use data from column A & B to ensure better accuracy in the data sheet:
-
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…
-
Sheet Summary Grouping
Allow for grouping content within Sheet Summary window that can expand and collapse.
-
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!…
-
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…
-
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) +…