-
Can I set sheet to show the sheet summary when a user lands on the page?
I'd like to display the sheet summary when a user lands on sheet, and keep the summary open until a user dismisses it.
-
Report: Sheet Summary - Update Field from Report
I'm trying to find a workaround the lack of functionality in Update Requests. I have a Sheet Summary field called "Project Update" where our Project Lead is expected to put a brief statement on their project weekly. That field feeds up to the Project Dashboard and, subsequently, a Portfolio Dashboard to provide an update…
-
SUMIFS with Multiple Criteria
I have worked up SUMIFS that sums the Final COS for each of main Account Managers individually and for multiple codes in a contracted column that equate to a loss (this worked out fine): =SUMIFS([Final COS]:[Final COS], [Account Manager]:[Account Manager], "Doe", Contracted:Contracted, "not won") + SUMIFS([Final…
-
Sheet Summary
Hi, I am writing a formula that is using data from sheet summary. I am blanking on the symbol used either before or after to pull in the field from sheet summary. Thank You!
-
If a date is between 1.01.2020 and 31.12.2020, get the cell checked
Hi everyone, I have a list of documents that have been uploaded throughout different years. I would like to count how many of them have been uploaded in 2020. For this reason, I would like to create a column where the cell will be checked if the column "Date Uploading" is in 2020 and then report it on the Summary Sheet. Is…
-
Pulling data from two sheets' Sheet Summary into a YOY chart in a dashboard
I've been collecting data on total completed projects for several product lines in the Sheet Summary panels for this year's and last year's project tracker sheets. I'd like to make a two-color bar chart widget, with each year in a different color, showing the change year over year for each product line in the number of…
-
Using COUNTIF in Sheet Summary
I am trying to use a COUNTIF formula in the Sheet Summary. I have a column called, "Current Project Status." I want to count the total number of times the word "Operational" appears in that column. I have entered this into the field with no luck; "=COUNTIF(Current Project Status:Current Project Status,Operational)" I have…
-
Formula range extends to include new rows/entries. Sheet Summary
I'm using Sheet Summary to sum amounts on a sheet where new entries are occasionally added via forms. I want the new entries to be included in the range of cells summed, but that's not happening. Any tips?
-
Sheet Summary Report From Smartsheet Into Appsheet
Greetings, I'm attempting to retrieve a Sheet Summary Report as a 'read-only' table in Appsheet. The error I'm receiving... The report you are attempting to open is a sheet summary report, which requires a query parameter of 'level=2' (or higher if available) to be specified in the API request. → Error 5623 in…
-
Sheet summary - count of Status from multiple source sheets
Hello, I have 7 source sheets that I would like to use for a sheet summary report. Only one of the sheets is returning values to the report. All the sheets have the same 'Status' column, with the same values in the dropdown. Question is: why is only one sheet returning values?
