-
Nested IF/AND Formula
I'm receiving an #UNPARSABLE error for the following formula: =IF(AND([Completion Status]@row="Completed", [Actual End Date]@row<=TODAY()), "1", IF(AND([Completion Status]@row="In Progress", [Actual End Date]@row> TODAY()), "2", IF(AND([Completion Status]@row="Not Started", [Actual End Date]@row> TODAY ()), "3", "4")))…
-
Using SUMIFS with YEAR and MONTH from single referenced column
Hi all, I'm trying to create sheet that will sum up all revenue for a year, by month. End result should look something like this: I'm using this formula and receiving an #INCORRECT ARGUMENT SET error: =SUMIFS({anrev}, {vehicl}, "Site", {Scale Date}, IFERROR(YEAR(@cell), 0) = 2020, IFERROR(MONTH(@cell), 0) = 1) (this is for…
-
IFERROR MONTH
#UNPARSEABLE error when adding the MONTH function. =COUNTIFS({Incoming Quality 1}, Quality@row, {Intake Sheet Range 1}, IFERROR(MONTH(@cell),0) = 4))
-
Is it possible to create uniquely identified numbers using level 1 parent tasks as a baseline?
Is it possible to pull the first three letters of a parent task, and then give it an unique identifying number xxx-9999? I have groups of tasks that I would like to create an ID for whenever there is a newly created line, each line would inherently be a child to parent task. For example a subtask of an "Engineering" group…
-
LEFT Function
I want to add a "0" to the left of any number with just 5 digits and just duplicate any number with "H" in front.
-
Querying my sheet
Hello, i have these two columns: ESTIMATION PER HOUR (number) RESOLUTION (numbers) I want to query the sum of all ESTKM2/H matching if RES=5 and divide it by the number of items matching this query. In the end i want to calculate the mean of estimation among all resolution 5 jobs. The result would be something like= the…
-
Getting an image approved - how to set Approval Status from multiple cells, ignoring blanks
Hello! I have an image production process sheet that at the moment requires 1-3 approvers per image. The images to be approved live in a cloud drive - they do not get attached to the Smartsheet. Basically, when there is a contact email in an Approver cell, I need a formula to check what the Image Approval Status is. Here…
-
Cannot calculate checkbox column
I am trying to calculate the number of checked cells in a column (named 'Done'), however I keep getting errors! The checked ('Done') column in question is pulling from another sheet using index links so will throw up a tick in the check box and a #NO MATCH accordingly. The calculation i am using to pull from the checked…
-
How do I create a formula that covers two sheets ?
Hi, I currently have this formula in use and I'd like to include one more sheet. How do I do that? Thank you! =COUNTIF({Master Data - National (Atten how did you hear)}, Label14)
-
Formulas with reports
Hi, I've combined two sheets into a report and I was hoping to do a summary sheet with various sumif formulas based on the data in the report. When I build the formula, the report is not an option in the list. Please advise. Thank you!