-
How to pull the top parent to the row
I need a way to consistently pull the top-level parent to all rows below for our reports. Here's an example: In this case, all of the apples need to have "Alpha" on their row. Similarly, all of the variations of Ed, Edd, and Eddie, as well as Easy and Edison, need to have "Echo" on their row. So on and so forth. Right now,…
-
Trying to add form submissions onto a Spreadsheet that has a column of unique randomized numbers
Hello all, I was wondering if someone can let me know if there is an easy way or even a workaround to my issue. I have a list of randomized coupon codes in a column, and I need the form submission to populate the next available row with a coupon code. The issue I have right now is that, I have the column of 500 coupon…
-
Help with # of days Formula. Returning "#UNPARSEABLE" Error
I am trying to calculate the number of days between two date columns in my Smartsheet: "Date" and "Date Closed". If "Date Closed" is blank (indicating the issue is still open), I want to calculate the number of days from "Date" to the current date. Here is the formula I am using: =IF(ISBLANK([Date Closed]@row), TODAY() -…
-
Count If one column meets two criteria
I am trying to adjust some formulas we have for budgeting replacement computers. The sheet references another sheet and previously was just counting based on a date range to count computers due for replacement. I now wanted to expand this out further and use it to count Windows replacements and Mac replacements. I need the…
-
IF Formula Looking at Multiple Columns of Check Boxes
I have the formula figured out if only needing to rely on "looking" at one column: =IF([Approved?]@row = 0, "Pending", "Closed") I want to update the Status column to also take into consideration the "Approved as GRA Extension?" column. How can I write the formula so that if a box is checked in EITHER the "Approved?" or…
-
multiple checkbox column i need a formula to say if they are all checked completed
-
To much Dynamic data
I have 12 grids (One for each month) that have dynamic (Column 1)offices, (Column 2) Appt Types. (Column 3) Amounts for those appt types, I need to combine them into 1 report but the report starts over each month stacking. So i though i would combine all 12 months into 1 grid but then i end up with duplicates(Offices and…
-
Is there a way to copy what is in a row to another row if they are the same task?
Hi Everyone. Thanks for looking at my question. My manager has a sheet with 900 rows for collecting evidence. The problem is that a lot of rows have the same Task(Column) so instead of having to input all 900 individually the sheet will duplicate the ones that have the same task. Is there a way to do this?
-
Need Formula with nesting IF's help
Hi folks! Brand new to the community and this is my first help request. I've watched many you tube videos and read as much in the forum as I could about smartsheet formula's, but I just can't figure out what I'm doing wrong. Let me set this up for you: I'm trying to take names from a column in sheet 1, and convert them to…
-
INCORRECT ARGUMENT SET
Hi, First time poster here. I see there is a great community of users here willing to offer their expertise. I am struggling with a formula and am hoping to get some help. I would like to reference a different sheet to display an average score for a date range (by quarter) for each of our query authors. When using the…