-
Sum two variables while retaining the total for the next new number
I have two variables in my spreadsheet 'Number of Hours per week' and Total Number of Hours per Study'. I want the 'Number of Hours per Week' to add to the 'Total Number of Hours per Study' column per row. In this case the 'Total Number of Hours per Study' [10] would automatically change to 14 (Shown in Test Column). The…
-
How do I subtract days from a date
I'm trying to build a production schedule spreadsheet. In one column I have the date the production item needs to be completed. In the next column I have the number of days (just a whole integer number) needed to complete. I would like to use a formula to determine the date production needs to begin. Simply (Date to be…
-
Cross sheet Index & match with a filter to only pull through data that matches certain values
I've got a master tracker for our project- area by area, and then another sheet which gives a breakdown for drawings for each area and their approval status for example - one area could have 3 or 4 drawings related to it. Each drawing has to be approved before we can start work on that area. I want to create a formula that…
-
=Count not pulling number from cell on reference sheet
I have the formula =COUNT({Demo Room test requests Number of assemblies}) in a sheet which is counting the number of times there is a value entered into that row, not the actual value in the cell. It pulls "1" as the value instead of "5". Example 1 Example 2
-
Formula for finding across two smartsheets
Hi- I have two Smartsheets that share a 'Group' column and a 'Study' column. If I wanted to find out if there are studies that appear in both 'Group' columns, how would I write the formula? Could I use cross reference?
-
COUNTIFS with a Date Range
Hello there, I am needing help with a formula, i am trying to count the number of faults that happen per week. I have the below so far but it is coming up #UNPARSEABLE =COUNTIFS([Faults]:[Faults], [Week Starting]@row >= [Week Ending]2 <=,[Week Starting]@row >= [Week Ending]2<=)
-
COUNTIFS using MultiSelect as criterion
I have a sheet that is tracking all of the tasks users need to do in a year. They enter the recurrence of the task as Daily, Weekly, and Monthly. They also enter the Start Date and End Date (ex. 3/15/2023). I then create rows for each month the task is running. So 3/1/2023 - 5/31/2023 would have three rows (March, April,…
-
Change Cell Value with Condition Automation Workflow Issues
Hi, I have a multi-tiered approval process that is working as long as the team manually changes the status. Naturally, we want to automate this process for the approval workflow to run seamlessly. Except, I can't get these to work. Here are my screenshots: I have other workflows created based on each tier (we have 5…
-
Return the month of a closed item
Hi, I'm trying to create a formula for when a query is closed and the month is return in a separate column. I have managed to complete this for the month the query is opened as all items opened have such a date. However, if the query is not closed the cell is blank and I receive the following error message "#INVALID DATA…
-
Using an OR in COLLECT
Hello - I'm trying to use an OR operator in the criteria of a collect function. This is currently returning an #INCORRECT ARGUMENT SET: =IFERROR(INDEX(COLLECT({WAP Deposit Number}, {WAP Date}, Date147, {WAP Type}, OR("CHECK", "CREDIT"), 1), "")) I'm trying to return the a deposit number {WAP Deposit Number} if the Date…