-
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…
-
How to create a Sheet Summary for the last 7 days ?
I am trying to find out how to summarize (count) the number of items that have been completed in the last 7 day? but my formula is reading 0? i think there might be a syntax error =COUNTIFS(Complete:Complete, "0", Created:Created, TODAY(-7))
-
Specific cell reference in update request text
Hello! My examples are in French, but as SS is the same, you should understand with the visuals. I used a template as a base for my project management office. In this example, we create a folder with the project name, but all the subfolders remain “generic” in order for the links between them to continue working if we make…