-
Check for Payments Requests for Same Project
I have a sheet that collects forms submitted by Program Developers to request payment for work on program development. For the Payee, they can select a [Role] that is either Instructor, Subject Matter Expert (SME), Co-Instructor, or Co-SME. If they choose Co-Instructor or Co-SME, they are asked to enter a [Percentage] of…
-
AVGW Formula for Multiple Cells in One Column
I am trying to apply weights to multiple cells in a "% Completed" column. My current formula just averages out the values for the selected cells: =AVG([% Complete]3, [% Complete]5, [% Complete]7, [% Complete]9, [% Complete]11, [% Complete]53) I'd like to apply weights of 10% to row 3, 5, 7, 9, and 53 with a weight of 50%…
-
Count or Sum formula
I want to sum the columns that contain 1 and have tried a SUMIF and COUNTIF Formula, as well as using the AI formula generator within the sheet - nothing is working. As you will see from the screen shot below I would be expecting this column to return a value of 7 but, it just returns 0. I know it's going to be something…
-
Calculating time
Hello All, I'm a new user to Smartsheet and am trying to figure out the formula for calculating time. I have a start time column and an end time column and am trying to figure out the formula to calculate the amount of time in minutes. Any help would be appreciated!
-
Invalid Data Type after automation runs for TODAY HELPER
Greetings, I have a simple rollup Sheet that all formulas change to #Invalid Data Type after my "Today Helper" automation runs. If I open the sheet and save, it goes back to working (no changes). I have no TODAY() functions AND I am using a Today Helper column. Example of the formula. =SUMIFS({Safety Incidents Range…
-
How to flag duplicate dates within a range
Hi everyone, I'm attempting to build an annual leave tracker for my team. The current build is the employee completes a form with Start and End dates > this updates on a Request Log for managers to Approve / Decline > once Approved, copied to a master log and a separate Tracker sheet keeps a list of all employees, their…
-
IF AND Formula with Multiple Criteria
Hi there, I've searched so many threads and tried parsing together how this would work for my scenario but I keep getting an invalid argument. I have a column for "Status" and I want to incorporate a formula to auto select the status based on other cell criteria: Open: If "Date Shipped to Supplier" is blank At Supplier: If…
-
Returning a Cell with Matching Data
In a summary collection sheet (Sheet B), I want to capture a certain price in my data collection sheet (Sheet A) Sheet A has data input: In sheet B, I want to return the cost only if Material and Part are equal. I was having trouble using the Index(Match) formula and was hoping someone could guide me to the correct formula…
-
COUNTIFS to count all rows in another sheet where Status is Accepted
This discussion was created from comments split from: COUNTIFS with Multiple Criteria.
-
My formula is not working, for one specific line in my task sheet. why does it not work
This is the formula, I receive Invalid in the cell =IF(AND(MONTH([Start Date]@row) <= 1, MONTH([End Date]@row) >= 1, YEAR([Start Date]@row) <= 2025, YEAR([End Date]@row) >= 2025), 1, 0)
