-
Help with error Incorrect Argument Set
I'm trying to use this formula =SUMIFS(CHILDREN([Reimbursement Amount]:[Reimbursement Amount]), [Reimbursement Date]:[Reimbursement Date], >DATE(2024, 1, 1), [Reimbursement Date]:[Reimbursement Date], <=DATE(2024, 12, 31)) But I keep getting the end message, incorrect argument set. I'm using this as a summary sheetβ¦
-
I get and "#incorrect argument set" when I wrap my IF statement with IFERROR to replace the "#INVALI
I get and "#incorrect argument set" when I wrap my IF statement with IFERROR to replace the "#INVALID DATA TYPE". Please tell me what I am missing? =IFERROR(IF(MONTH([Incentive Date]@row) = 1, "January", IF(MONTH([Incentive Date]@row) = 2, "February", IF(MONTH([Incentive Date]@row) = 3, "March", IF(MONTH([Incentiveβ¦
-
Reference or copy a column in one sheet to another sheet automatically
Hi, I am trying to figure out a way to automatically get specific columns in one sheet, into another sheet I was originally looking at using a workflow to copy the rows over, but I only wanted to copy a subset of the columns which doesn't look to be possible. Then I started looking at cross-sheet references, but the postsβ¦
-
SUM FORMULA BASED ON MULTIPLE CRITERIA
Help PLEASE!!! I am looking for a formula that will sum the total travel cost of resources, if selected, based on the qty of each resource and also the resource rate (from another data sheet). For this example I have 3 travel items: Line 1: I have 3 resources which will be traveling, project manager, design engineer and aβ¦
-
How to calculate parent-level values in multiple columns (not just % Completed)?
Hi, In my project sheet, only the % Completed column rolls up automatically using parent/child logic. That works fine. But I want to do something similar in other columns, like: Variance from Baseline (%) Weighted Variance Planned Progress (%) These are all calculated row by row, but I want to show an accurate value at theβ¦
-
Formula To Count The Number of Days an Incident Occurred
I am building a safety event submission sheet and I wanted to add some metrics to a dashboard. If an event is submitted, that day is considered a "Red" day and if no events were submitted it is a "Green" day. The goal is to make a chart that shows number of red days out of the month. A day will be considered red regardlessβ¦
-
Count value in columns
Hello, I have a question about creating a specific formula. What I want to know is: how many columns has a value? From the columns Dgn_Funct, Dgn_DEV, Dgn_Int, Dgn_ BI. What is the best way to set up this formula? I tried several one but not found the best. The result will be shown in the blue column, this will be 0, 1, 2,β¦
-
Reference the value in the row above and change this cell value as a result
In excel I would use the formula: IF(A2=A1, C1+1,1) What this allows me to do is say, if the value in column A on this row matches the value above it, then increment the value in this cell, if not start again at 1. When you create a formula like this in excel you can fill it down and therefore have every row reference theβ¦
-
Show Multi-Contacts with a JOIN(COLLECT(...) formula -- working, but not showing as contacts
I have a Directory Sheet ('Sheet 2 -- Directory': https://app.smartsheet.com/b/publish?EQBCT=a3e35afe3e02404692195182d00936a4) with a list of Teams, Departments, and Contacts. I want to pull the Contact(s) into another Sheet ('Sheet 1 -- Pull Into Sheet':β¦
-
I Need help and support on a formula I am using
=IF(HAS({1st day of the week}, Date@row), OR(HAS({2nd day of the week}, Date@row), INDEX(COLLECT({Clinical Placement Tool Status}, {Hospital Site Name}, [Hospital Name]@row, {Unit Name}, [Unit Name]@row), 0))) Is the formula I am using it is partially working. When I look at the results in column where it should be pullingβ¦
