-
Nested IF Formula Troubles
We are trying to use a nested IF formula to use two different sets of criteria to return two different results. I feel we are close because we get an Incorrect Argument error, rather than the dreaded Unparsable, but I am not seeing what we are missing. We also tried adding a "" as a return if False value but that didn't…
-
Formula to Find combined cell total if criteria is met.
Hello, Please Help!! I am working on a metrics sheet from an onboarding sheet. I am trying to find the total of FTE for each department. I have a column called "FTE" which has various numbers in over 200 cells (e.g. 1, 0.78, 0.25 etc.) and i have a column called "Department" which has 5 service areas within the…
-
Including a checkbox column in formula returns "INCORRECT ARGUMENT SET"
Hi all, I am trying to make a formula that Calculates the hours spent on tasks with certain conditions. I have 2 arguments in my formula that are currently causing it to return this output. Here is the formula: =SUMIFS({Custom Engineering Requests: Days To Complete}, {Custom Engineering Requests: Drawing Category},…
-
Add Count Unique function
Please add a COUNTUNIQUE function (or COUNTU for short). It's a pretty self explanatory and similar to other COUNT functions. My intent is to have an automatic Project ID number that is based on the unique project title and I can have multiple entries of the same project title without the ID changing. There is a work…
-
Formula to return Monday from a week a date was on
Hello, I'm looking to put together a formula that will pull the Monday a date was on so I can then pull things that were 1 week ago, 2 weeks ago, etc. to build out a report for weekly hours done by members of a team. I've tried some other methods to try and do this but they broke on the year change because Smartsheet just…
-
Need Help With Colored Health Status Formula
Hello, I have a symbol column that automatically will assign a color (currently either red, yellow, or green) based on a due date in a column called "NEED ON SITE DATE". The formula looks at the "Fab Status % Complete (Needs Real Numbers)" column and will assign it a green dot if the percent complete is 100%(In this case…
-
Index Collect or Lookup Formula Help
Good Afternoon All, Currently having trouble with an index collect formula between 2 SmartSheets. On Sheet A there are 50 Unique ID's that correspond to 50 Creative Names on Sheet A. On Sheet B I am trying to bring those 50 unique Id's over by matching back to the 50 Creative Names on Sheet A. So my formula is as such:…
-
Cross-Sheet MATCH INDEX ERRORS
I am running in circles trying to solve this issue - seemingly, in using MATCH() on an external cell reference, the value it returns caps itself at 14 even though data goes out to ~30. While I end up using this base function in much larger equations, the screenshots explain the basis of the issue: Here is the Cell…
-
formula for multiple criteria
i am looking for a formula to track progress / multiple statuses migrated = 100% decommissioned= 100% In Progress = 50% Incomplete - reporting error = 0% Not Started = 0% Failed in PROD = 50% Decom Candidate - 0% what formula can i use to get a update in a column if any these statuses reflect
-
COUNTIF with OR
I am trying to count all instances of a name where the corresponding status is Open or Tracking. My formula is =COUNTIFS({Coordination Log - Autumn Willow Range 1}, "Chris Rush", {Coordination Log - Autumn Willow Range 2}, OR(@cell = "Open", @cell = "Tracking")) In the last portion where the OR comes into play, I initially…
