-
How would you combine the CONTAINS or HAS function with a SUMIFS formula?
I am trying to create a formula which sums the total number of machines we have delivered for certain projects, but in the "Project Name" column, we have different stages of the same project which I want to combine. E.g. Project Pearl 1.1 - 5 machines delivered Project Pearl 1.2 - 5 machines delivered Project 1.3 - 5…
-
Counting number of times Name appears in multiple contact column
I have a column set up as a multiple contact to capture all authors on a journal publication. I would like to use a formula that will count the total number of times a specific name appears in then column. I have tried =COUNTIF({ALL AUTHORS},"John Doe"), but I know it does not yield all of the times the name appears. I…
-
IF and IFCOUNTS to reference across 2 other sheets
Hey community - We are migrating from excel to using Smartsheets. We have a lot of formulas that are being migrated over as well within these sheets. Here's the fomula working very well in excel: Sheet names referenced within the same book in excel are: Ignore Opps Account Assignment_Round 1.Refresh Customer Doc…
-
Index/Match with 2 sheets
Hi all! First, thanks for taking the time to help me, it is greatly appreciated. I am trying to do an INDEX/MATCH since I can't use XLOOKUP (and this is to the left). First, I created a Unique ID with the JOIN feature to help me accomplish this. That formulas is: =IF([Release Name]@row = "", "", JOIN([Release…
-
Datasheet reference URL
I have a column with the link to another datasheet, how can I write the full URL into another column?
-
Formula for only parent rows
I created a helper column to sum all the children rows under a parent row. I want to now create a column formula that only applies to the parent rows, that populates whatever is in the child row below the parent row into the parent row. I have it working if I apply the formula to each parent row but can't get it to work as…
-
Rolling Date based upon checkbox??
I have a spreadsheet with a Date Column that is populated weekly. If we get to that date (or even better, 1 day before) and the checkbox in another column is still left unchecked can I get the Date Column to automatically increase by 1 day. I need this action to continue until the checkbox is checked. Thanks!
-
Ranges
Hi, I am using "Ranges" when I use vlookup etc, but I don't know how to completely delete a Range (or multiple Ranges) Does anyone know how to delete all "old" ranges from within smartsheet memory? I think I need to free-up some resources, I keep getting the error message; "You can only reference 25000 cells" "Please…
-
What is the maximum number of rows that can be added to a sheet?
I've searched for 'Row Limitations' on the help center, and haven't found an article which explains clearly so asking here. What is the maximum row limit (vertical, up to down) on a single sheet? I've seen both 5000, and 20000. Additionally, is there an article where this information is contained?
-
Countdown for days until due but stop counting after due date has passed
Hiya, I am trying to write a formula that will count the number of days until a task is due but will not start showing negative numbers once the due date has gone by. I came up with =NETWORKDAY([Today's Date]@row, [Date Next Check/Validation Due]@row) But couldn't figure out how to make it be blank once the Date Next…