-
Filters in reports
Is it possible to filter in a row report for a field which is in the sheet summary report? I mean I need to create a row report, but also need to have a visualization based on a single field which I only have in the sheet summary report. This way it would clearly be a way to get a filter on a list of sheets to put in my…
-
Create a cross refference formula that meets multiple criterias
I am looking to Create a cross-sheet reference formula that meets multiple criteria. see screenshot
-
Formula to calculate the average number of days between all dates in a range
I have tracking sheets that record "sent" and "executed" dates. I am attempting to set up Sheet Summaries to determine the average number of days between all "sent" and "executed" dates in the sheet. (I want to do this without adding an additional column and calculating averages for each row). It seems I need some type of…
-
Sheet Summary shortcut
Hey All! My team is looking to add sheet summaries to already existing sheets. Is there a better way to add the fields than going into each sheet one by one to add them? Appreciate any answers! 😀
-
How to add new criteria to my current COUNTIFS formula?
Hi all! Not sure how to add the criteria do not add to count if cell = "Topic" to my current COUNTIFS formula. Current foluma is: =COUNTIFS(CHILDREN(Plan:Plan), "Fundamentals", CHILDREN(Role:Role), HAS(@cell, "IBX Customer Ops")) I need to add 'AND if the the "Deliverable" cell does not equal "Topic" '. Thanks in advance :)
-
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…
