I am having some trouble with creating COUNTIFS functions that reference cells across multiple sheets. I'm trying to create an active dashboard that will reflect performance data over the following periods: month, quarter, year. I want the COUNTIFS function to reflect the number of rows that meet the following criteria:…
I created a pretty intense sheet to keep track on invoices and receipts. I have an "Action" column that is a drop down column. Here are a few of those "Actions" Request Sponsorship Submit Sponsorship Request Invoice Call to pay with CC Call back to pay Submit Check Request Follow-Up Check Approval Mail Check Out Request…
I have - a column containing start dates, that spans 2019 a column containing an assortment of names that re-occur on a random basis. I want to count how many times each name occurs each month. Any help appreciated!
I have an end user I am trying to build a records sheet for and I can't figure out how to accomplish a change count cleanly. We have thousands of rows/records in a sheet with one of the fields/columns being a Status.They do a monthly review of how many records moved to different statuses in that month and I want to…
For some reason my indent and outdent is greyed out and unavailable. I can't figure out what I am doing wrong. Any ideas is very much appreciated.
Hello, My team is tracking hours spent on assigned tasks. We have our SpartSheet set up with: Parent Row : Date, and Total Hours spent for Child Rows Child Row: Team Member, and Hours spent I am looking to see if its possible to get how much time each team member is spending in total
I am trying to count the Stars that are checked across multiple sheets. I can’t seem to get a formula to work. Would anyone know?
Hi I would like to know how to set up a rule where if a certain selection is made from a drop down in a cell that it automatically prompts you to complete a related cell. For example: If a member of my team update the Recruitment Status for a vacant role to show 'Offer Made' I would like a prompt set up to automatically…
Hi all I have a sheet that I use to track recruitment activities within our team. Each role is assigned to a member of the team and has a recruitment status attached to it. I am trying to pull this information into my dashboard to show how many active roles each team member has on the go. However, I only want to select…
I accidently deleted a sheet that contains important inormation and I didnt create a backup. Is there anyway to recover my sheet?