-
SUMIF error
I'm stumped on another formula. I receive an "incorrect argument set" Total [Dave Delivered] if the month is January =SUMIF([Actual Date Completed]3:[Actual Date Completed]46, MONTH(@cell) = 1, [Dave Delivered]3:[Dave Delivered]40) Thank you
-
What formula do I use for Grading?
I have a sheet used for grading our product. There is a final score for each product out of 36. I would like to use a formula that uses the final score to give the product a "Grade". 0-12 = C, 13-23 = B, 24-29 = A, 30-36 = A+ How do I set up a formula to kick out a letter grade in a cell depending on a range of numbers in…
-
Helper Sheet Help
@Andrée Starå has mentioned on multiple posts about creating Helper Sheets when trying to manipulte data to have certain rows copied to other sheets. I'm completely stumped where to start with the cross-reference formulas to make that happen. I have a master sheet with a lot of columns, some of the data in the master needs…
-
Max Collect formula help
Hello I can't seem to troubleshoot this formula. Return the latest date [Planned Date Completed] associated with "1" [SOW Billing sequence]. Any idea why it's returning 0? Thank you! Lauren
-
Too many Formula Cell references
Hello, I received this warning in my Smartsheet and am not sure why? I have about 36 columns and ~2400 rows, 11 columns are formula columns. Do I have too many formulas? I have 6 cross sheet references. Appreciate any help.
-
Incorrect Argument Set
Please help: why am I getting this "Incorrect Argument Set" =SUMIFS([Targeted Area]:[Targeted Area], "Atopic Dermatitis", [Approved 2022 $$]:[Approved 2022 $$], 1) This formula uses 2 columns [Targeted Area] and [Approved 2022 $$] (which has the $$ approved amount) and says... look at the "Targeted Area" column, if it is…
-
Display Hours & Minutes (Time) as Minutes
Good afternoon all, I have a column that displays time taken to do a task in this format: H:MM I would like to have a column at the end of my sheet that displays this information in minute format. Please can you help with the formatting. Thank you
-
Using IF to return a value from another cell
Hi All, Currently we have the below system in place to return the value of a specific cell out of a specific column. So for example, If the country is Germany it pulls the information out of the Germany Column. This works great! But now comes my problem. We have added a Germany Refurbishment Column. So now it should work…
-
Where in this formula would I add in within 1000km
I use a smartsheet to track my fleet. When something meets this criteria it ticks the box and then an automation is activated. I was wondering how I would change this so somewhere in the formula the km's were within 1000 or over the RUC amount. This way before it is overdue, it sends the email. Here is my current formula…
-
How to convert to a date
HI all, I'm trying to get a text string from one column (lot code) converted into a date in another column. The first column contains numbers such as: 202405 Ideally the date column would read the first four digits as a year, and the last two as the month (all of the days can be the first). So far I have: =DATE(LEFT([LOT…
