-
Sumif question
I'm trying to get a sum of one column based on choices from 2 other columns that have drop down choices. This is the formula that I entered based on the AI chatbot suggestion. It did not work. I am NOT a SS genius. =SUMIF({Quote Status:Quote Status}, "In Progress", "Bid Submitted", "Results Pending", "On Hold" {Bid Success…
-
Dynamic drop-down options based on a selection in another column?
Hello! I have a "Client" drop-down box with 50 options. For simplicity's sake I'm just going to pretend these are values of 1 through 50. Many of the values in the drop-down are only relevant to certain teams based on their geographical location. If possible, I would like to only show the relevant options based on the…
-
Why is December's NETWORKDAYS formula not calculating correctly?
Hi - I have this formula that works perfectly for the year, but when I get to December it is calculating an odd negative number. Can anyone help me understand why and what I need to do to correct it?
-
Sudden Invalid Operation Error
I can see from our audit trail that, on 9/18/24, some of the formulas in our summary sheet suddenly switched from their calculated answers to #INVALIDOPERATION but I can't figure out why. Here's an example: =SUMIF(Status:Status, "Open", [Extended Cost]:[Extended Cost]) This formula seems correct to me… for all rows where…
-
Creating a simple sequence formula for the column
Is there a simple method to create a sequence column in a helper sheet based on a specific number to start the sequence? To give an example, I want to sequence start with the number 25 and increase each row by 1 (ie. 25, 26, 27, etc.), not by any specific project or identifier, simply starting with 25. I thought selecting…
-
Formula to calculate 30 days before
Hi, I have a column with a Partner Due Date (manually entered), and a column with an Internal Due Date (column formula). I would like for the Internal Due Date to be 30 days before the Partner Due Date and am using this formula: =DATE(YEAR([Partner Due Date]@row), MONTH([Partner Due Date]@row) - 1, DAY([Partner Due…
-
Formula help - change date format based on drop-down selection in another column
Hello all! I have a sheet that is being used by people in the US and the UK. Users have requested that the date fields for their projects be formatted according to whichever region they're located in. I have a column named "Region" where they select a drop-down with values of US and UK and then multiple date fields on the…
-
I'm wondering if its possible to do a formula that has X task averaging A hours.
Is there a formula that would be able to pull from a Smartsheet that it smart enough to be able to pull from multiple columns. Ex below. Say I wanted to pull the average amount of time (duration) for the "eat" task in year "2023", how would I go about this?
-
Return different value based on date
Hi, I'm trying to write a formula to return different values based on the reference date ([Next Calibration/PM Date]@row) compared to today's date. I want the equation to: If the cell is blank, return as "Pending", If the date is < = today, return as "Overdue", If the date is > today, return as "Current", If the date is…
-
Assistance with an AND formula
I'm trying to use COUNTIFS - I have a column with multiple items and only want Client Success to be counted; the item also has to be In Progress; the below schema is not working: =COUNTIFS({Small}, HAS(@cell "Client Success" ), AND({Status2} = "In Progress")) Any help is appreciated.
