-
SUMIFS only if separate cell contains certain text from a different sheet
Hello, I cannot get this figured out unfortunately. I have a basic knowledge of functions with Excel but it doesn't seem to be transfering over into SmartSheet. I am trying to SUM dollar amounts based on a few different criterion, but ONLY want the SUM IF a different cell contains a "YES". I am pulling this information…
-
Calculate cell value based on various cell look up functions
Hello Everyone, I am trying to create some automation in my SmartSheet that will automatically calculate the estimated cost for a project based on 1) type of project 2) production hours 2) estimated development hours (based on production hours) 4) how much the cost will be based on hourly cost For example, I have the…
-
Create a column that indicates # complete a task should be per the start and finish dates.
I want to create a column that indicates # complete a task should be per the start and finish dates. This will allow the user to compare expected vs actual % complete. I have a helper column already that does this for the Risk Flag formula, but it can actually go below or above 0-100% depending on when the start and finish…
-
Countifs no longer working
Hello, I have a countifs formula that was working and is no longer... This is for my "metrics" sheet so the information is being pulled from the Garage Access Issues Log onto another sheet so I can use it in a Dashboard. I'm trying to count how many issues are showing as unresolved and not archived. Both the 'Resolved' and…
-
Nested IF CONTAINS, Return Blank When Contains Blank
I've searched the Community and haven't found this situation, so I appreciate any help. I have a data set in which I'm trying to write a nested IF CONTAINS formula to return the primary program based on what is contained in the Project ID field. My current formula is =IF(CONTAINS("ABC", [Project ID]:[Project ID}), "ABC",…
-
Is there a formula that can check if a row has an attachment?
I have a dropdown, single-select column that describes the type of action item listed on that row. For example: If someone selects the Star symbol on that row, the column formula calculates that the action item is a Milestone and returns the "Milestones" option from the drop-down options. I would like to indicate when an…
-
Count Ifs for Multiple IF fields
Hello, I'm trying to write a formula that calculates the remaining items in an inventory category and within a certain date range. This count ifs would subtract from a fixed number everytime we restock inventory. The inventory total on 8/22 for item #2 was 45. My team creates a new row everytime an item is distributed at…
-
HELP! My status formula is not quite working as expected..
I am struggling with a game of formula "whack-a-mole" lol This is my status formula: =IF([% Complete]@row = 1, "Complete", IF(OR(Finish@row < TODAY(), (Finish@row - TODAY()) / (Finish@row - Start@row) < [% Complete]@row), "Behind Schedule", IF(Start@row > TODAY(30), "Not Started", IF(Start@row > TODAY(), "Starts within one…
-
Strange Request of Rounding Down against Laws of Mathematics
I've had a strange request. One that defines the laws of Mathematics: I'm calculating the time difference and then using this formula to round down. However, the formula is following the laws of mathematics and rounding up when it sees an 8 or 9. =MROUND(ROUNDDOWN(Difference@row), 5) E.g. In this example, the requestor…
-
If statement referencing another sheet returns invalid operation
So I am using this: =IF({Master Bookings Sheet-V2.0 Range 1} = [Cutting Room Number]@row, "Unavailable", "Available") Above is the sheet where I'm checking the value of "Cutting Room Number" from another sheet called "Master Bookings Sheet V2.0". I have to check: if the value in "Cutting Room Number" in the above sheet is…