-
Summary Sheet formula to count status by assigned person
Hi All, This should be a basic formula but I cannot seem to make this work for me and I am hoping that someone in the community can help me pinpoint where I am going wrong? I entered this in the sheet summary field - =COUNTIFS({Range - Standard Author}; StandardAuthor@row; {Range - Status}; "In Progress") noting the…
-
Someone please help me get the "=COUNT(DISTINCT(COLLECT(" formula correctly?!
HI there team, Trying sum up the Summary screenshot by unique Shops/Customer registered. Data is coming from the different file which is a registration file, and for some reason I cannot get the formula to work. Attaching a sample. thank you!
-
How do I sort by due date in a report?
Is there a way that once I have grouped in the primary data in a report I could sort by due date in that report? I have grouped the primary column and then summarized the start and due dates, but would then like to sort by the due date so the "Project-Interviewee#" and "Interview Name" is sorted in descending order by the…
-
Sheet Summary - Formula
Hi! Trying to create my sheet summary. I have one column, Orders Keyed, and a second column, # of errors. I have created a summary for each total. Now I need to get a percentage out of those. i.e. 18 errors out of 4308 is 0.42%. What is the right formula to do this?
-
Changing a sheet formula to a sheet summary formula
I am working on a donor management tool and am looking to count the number of donors previously identified as "lapsed donors" who are no longer in lapsed status. I have created this formula within a column in SmartSheet. It correctly calculates the status of Lapsed Donor change (+1 for new lapse, 0 for no change, -1 for no…
-
Sort by Sheet Summary fields in Row Report
Hello, I am curious whether there is a means by which I can use a Sheet Summary field to group and/or sort rows in a Row Report. For example, I want to give a group of sheets a "Priority" field (1, 2, 3, etc.) and then in a Row Report, be able to sort rows by the priority number associated with the sheet where the rows are…
-
Counting the number of items due in the next six months from today's date
Hi, I am struggling to find a formula that can count the number of items (each row represents a task/project) that are due in the next six months from TODAY (the date of viewing). At the moment the below formula is incorrect ... =COUNTIF([Target Closure Date]:[Target Closure Date], IFERROR(MONTH(@cell), TODAY(MONTH(+6))))…
-
Drag and Drop or Move Summary Sheet Fields
Is there another way to move fields other than just the move up or down with one increments?
-
Summary Sheet Symbols and Projection Question
Hi, I am trying to do a few things. First, I would like to pull symbols into the Sheet Summary based on the following criteria: Most Recent Entry for Site A. Pull symbol from the "▲ ▼" column. Second, pull the... Most Recent entry for Site A. Pull symbol from the "Status of Goal" column to sheet summary. Lastly, I would…
-
Summarize tasks for assigned teammate on an intake tracker
Hi there - I am not understanding how to use this COUNTIFS formula above. I am in the process of creating a SmartSheet dashboard for my team from an intake tracker we have. I would like to use the metrics widgets which require sheet summary formulas. Problem - I am trying to create a sheet summary of how many current tasks…