I would like to see changes to the report criteria that determines what data is pulled into the report. I have a few different admins that have access to a report. What the report pulls in from the sh…
Hello, I have a sheet that tracks donations as they are received; name, email, and amount of the donation. Some are one time donors, others are repeat donors, and I would like to create a summary page…
Hi, Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering…
I used to see the login history of the users in my organization. Unfortunately once I deleted a user I cannot see their login history anymore. How should I go back and retrieve the history of actual a…
Hello. I'm new to formulas and need help. I'm trying to figure out how to get the total % complete for a column of check boxes. We need to know the % complete by milestone (which we figured out) AND t…
Hi. I'm sending a link to my report in an automated workflow as an "Alert Someone". The recipient email contains a link to the report and a snapshot of the report, but it is limited to 100 rows. A mes…
I'm trying to create a formula for a report that references another sheet but it needs to reference and check two columns. My crude formula below to illustrate: =COUNTIF ((RefSheet1Range1)="Windows Se…
I need to write a formula for counting active projects that are past due for a current month based on schedule complete date being in that current month and when actual complete date is blank. Project…
I am trying to use SUMIFS with multiple criteria, and I am failing horribly. I seem to be having trouble when I try to add the criterion to sum data from a specific year (from a Date field) and/or whe…
I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the t…
