Formulas
Discussion List
- 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 …
- 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 …
- 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 th…
- 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 u…
- 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 me…
- 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 …
- 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 t…
- 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 …
- 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 Ca…
- 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 - A…