-
Countifs for items completed YTD by quarter?
Hi everyone, first time poster here. I need a formula that will count Buy closings YTD by quarter. The best guess I have after reading other posts is: =COUNTIFS([Buy close date]:[Buy close date], > DATE(2021,01,01), [Buy close date]:[Buy close date] < TODAY, [Closing Q]:[Closing Q], Q1) It's not working but I can't quite…
-
Nested COUNTIF with AND
I am trying to use a nested COUNTIF formula with AND function. Column X - check if value is "1" Column Y - check if value is "2" Column Z - check if value is "3" I only want to see the count where all three statements are true. Help!
-
Trying to calculate an "on this day" capacity
Hi There, I have a master sheet of multiple projects. I am trying to work out how an allocated resource can show if it is over capacity in a column - similar to the resource view but so it shows in the sheet itself. So If I have Task Start Date End Date Duration Assigned to Allocation % Hours per day I want to look up the…
-
Formulas not copying to next rows
We have had some issues where the formula is not calculating on a new row when a new form is submitted. The only thing I can see in the activity history is that the new form row came in at 10:24:42 and the row above the new one was being worked by a staff member at 10:24:45. Has anyone seen where formulas stop working if…
-
Error when adding index linked formula
Am getting attached error even though all data is pulling into the sheet correctly, I have info pulling in from 2 x separate sheets. Can anyone confirm if this is impacting data or just an error I can ignore? Thanks
-
#Invalid Operation when determining whether date is in the past
I am working on answering someone else's question, and have come across an issue. I am perplexed! Can you please help me? The formula is to determine whether the planned end date is in the past. If it is, it's to show "Overdue"; if it's not, it's to show "Current." (There will be much more to this formula later, but I'm…
-
Cross Sheet Formula - Count how many times a date appears within a date range
Good morning, We have a log sheet that is constantly building on itself for when we communicate with a client. We call it a "touch." I am trying to count how many times we have had a touch per week of the year. I thought this would be simple, but for some reason I am struggling to make this work for me. Hopefully the…
-
What formula(s) would work best for this task?
Hello Smartsheet community! I have a question regarding what formula(s) would work best for a specific spreadsheet I am building. The situation at hand: I have a spreadsheet with data that has been submitted through a Smartsheet form. This data is connected to a users alias and tracks their completion of training. There…
-
Date Calculations
Hi there, I am trying to do a simple formula for a date to automatically populate in the Date Due column. I take the Event date and subtract the number of days prior to the meeting for each individual due date. This is the formula I created. However, when I run this formula in the Date Due column, nothing is returned. What…
-
Determine how many projects are active during given period
Hi all, I was wondering if anyone can help? I've got quite a number of projects running from Timepoint A to Timepoint B (several months) and wondered if it was possible to write a formula in my (separate or the same sheet) metrics sheet to determine how many projects are active during given month? For instance, I have 5…