-
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…
-
Can I display all the values from a column on one sheet to another?
Hello Smartsheets, I'm attempting to have a sheet which can display the values of a particular column on "sheet A" to a column on "sheet b." Sheet A's column has repeat information (job names) that associate with different items. So the job name on Sheet A shows up multiple times with different items in different rows. I…
-
Formula to calculate a date based off of Checkbox?
I am looking for a formula that will auto populate a column with a date once the "Checkbox" has been clicked in a different column. I also need the populated date to be the date the checkbox was clicked PLUS 2 days. Thanks!