-
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…
-
Center and middle justify summary fields in a report
I have created a summary field in my Smartsheet that is a formula: Overdue Tasks =COUNTIFS(Status:Status, <>"Complete", Status:Status, <>"Canceled", Finish:Finish, <TODAY()) Works just great! Returns a number that I would expect. The challenge is that when I create a row summary report that references the field Overdue…
-
Using sheet summary fields in an alert
Hi All, I have built a workflow where once certain conditions are met we send an alert to a few stakeholders where we give row details and reference some details stored in the sheet summary. At the moment I have not found a way to directly reference this information without adding a helper column to the row and using a…
-
How to find how many sheets are using forms in my account?
Is there any way to find out how many sheets in my account are using forms? (Short of opening up each sheet and clicking on Manage Forms! We have way too many sheets for that!) We need a way to estimate how many surveys our organization has out there. Thanks for any help.
-
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…
-
Merged: Tabs
This discussion has been merged.
-
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…
-
Copy Sheet Summary Field on a Sheet
The ability to copy an existing sheet summary field and edit to save with modified formula.
-
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: