-
Looking for formula(s) to determine number of months, weeks, days remaining.
I have a beginning date and an end date. Looking for a formula to determine the countdown but in month, week, day form. i.e. (3 months, 1 week, 6 days remaining until end)
-
Formula for counting unique orgnizations
I'm working on a sheet that counts touchpoints with organizations around our region. Sometimes, we meet with the same organization multiple times a month. I'm hoping to write a formula that can count the number of unique agencies we collaborate with within a time range. We collect the organization (which is also the…
-
Counting status' only when certain criteria is present
We are trying to create a formula that will count if 'Update Required' or 'Ticket Opened' or 'New Document Submitted' is found and 'SBR' is found in another cell Goal is for us to understand that from the SBR items, we have X amount of items pending This is what we are using but i think it's counting things incorrectly…
-
Help with index/collect (or maybe something else?)
Hi, I am struggling with index collect. I'm wondering if what I'm trying to do may not be possible with Smartsheet but I'm not giving up until I ask you wonderful people! I have a large Smartsheet with many columns and I'm maxed out at 381 columns, my license is only to 400 columns so while I could probably figure this out…
-
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() -…
-
Date Logic in Form
In forms it is not uncommon to have a Start and End date for any reason (mine is for PTO). It would be very helpful if there could be some logic added to Date fields to compare with other Date fields. In my case I need to add logic that prevents a user from entering an End Date that is prior to the Start Date. Today this…
-
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…