-
Date criterion leaves out value in results
I am building a report from 2 sheets. When I add the When criterion "is a date" from Sheet 1, the report data does not display the existing, not blank Property value from Sheet 2. Both of these sheets use the same unique customer ID for common value. What am I leaving out? Thanks
-
Reports Using Start Date Criteria
I am trying to build a report that shows all projects by quarter - those that start after Dec 31 and before Apr 1 would pull into my Q1 report, for example. When building my criteria I only see to have the option to choose starts after Dec 31 OR starts before Apr 1. I need to change this to AND, but don't see an option for…
-
Report Builder who criteria with multiple contacts
I am building a report in SS and want to see the results for all projects that have both person A and person B assigned. When I create my search criteria, I am selecting both person A and B from the list, however SS automatically shows it as: Teams Impacted has Person A or has Person B How can I change this to 'has person…
-
Keeping persistent dates for status changes
Building a kanban board with typical IT cycle states: Ready, Dev, Test, Deploy, Done. I'd like to track cycle times and throughput. I've created (locked) columns to capture a status change for each of the cycle states; e.g. Dev Start and formula "=IF(Status@row = "Dev", TODAY())". That works to capture the date that a task…
-
Report with multiple tasks as ("what") conditions
How do I create a report with multiple tasks (in my primary column) as conditions? E.g. I wanted to display sheets in a report where Task 3 = Yes AND Task 5 = No.
-
Nested IF(ISBLANK & Date Columns w/Progress Bar
Hi Everyone! I would like to know if you are able to use date columns when automating a progress bar. Basically dates are entered as product moves to a new stage in the process. As the dates fill in, the progress bar fills as well. I've used nested IF formulas for automating a progress bar but, for whatever reason... Im…
-
Current Task Formula based off certain criteria (symbols)
Hi, I want to create a formula that would read all rows have a Green symbol and read back the last task name that has green. This would have to be based off the row number and not dates, given not every task will have a start or end date. Attachment for context --> I would want the formula to read all of those tasks and…
-
Automatically repeat rows within a schedule (daily, weekly, monthly etc)
Hi, We use schedules to track publication output. Is there a way, when a form is completed or when a user adds to the schedule, an option can be selected to repeat the entry either daily, weekly, or monthly? Thanks, Dan
-
Cancel Scheduled Backup
Does anybody know how to cancel scheduled backups?
-
Reporting from multiple sheets into a single resulted row
Is there a way to run a report that looks at 2-n sheets that uses a common column (primary key like), like a Row ID, to import the data from several sheets into a single row of the report?
