Smartsheet Support Documentation does not have a way to duplicate, copy, or export a group in admin.smartsheet.com/manage/groups There is, however, a workaround that doesn't appear to be posted anywhere so I'm sharing it here: Open the group in the group list at admin.smartsheet.com/manage/groups Select "View Group" Select…
This is the simplest formula I can find to add Months to Date. This considers sum of months exceeding 12, converting it to January and adding 1 to the year. Where: Term column is the number of months to add, Date is the starting date. =DATE( YEAR([Date]@row) + INT((MONTH([Date]@row) + [Term]@row - 1) / 12),…
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 [info callout] The first one that…
I need to create a sheet that dynamically displays all projects assigned to me from another sheet called "Project Request Intake & Validation." Requirements: The sheet must update in real-time (if a project is removed from the source sheet, it should disappear from my sheet automatically) Each assigned project should…
Hello! I'm using an INDEX/MATCH formula to return the "Type" associated with a specific "Email." I'm getting a no match error when an Email value is first repeated. After the first repeat, the formula no longer functions. I've included my actual and desired outputs below. Both the form submissions data and the summary data…
Hi everyone, I’m rebuilding an Operational Status formula that references another sheet for quarter-end deadlines. The formula works logically, but Smartsheet keeps returning #UNPARSEABLE. Here’s the current version (I’ve confirmed all range names and column types are correct): =IF( AND( OR([Step 1: CQ LAUNCH Required (Yes…
Hello, I am trying to return data from a cell in a reference sheet based on (2) criteria - one at the row, and one in the 1st row of that column. I have metrics sheets that accomplish a similar function but those are using sumif for calculations, whereas here I just need to pull in text. How do I create an index/match or…
Hi everyone! I usually use INDEX/MATCH, but I am trying to "match" multiple criteria and found that it is better to use INDEX/COLLECT when dealing with multiple criteria. I keep returning "#INVALID VALUE" and am confused what I am missing… I have an "Audience" sheet my team is using with employees' respective name, ID…
Can someone help me understand how I can correct this formula? It's returning Unparsable. =INDEX({Revenue & Opex | ARRONI Row}, MATCH(TEXT(DATE(YEAR({Revenue & Opex Go Live Date}), MONTH({Revenue & Opex Go Live Date}) + 11, 1), "MM/DD/YYYY"), {Revenue & Opex Date Header}, 0)) The formula is indexing a full row. Matching a…
It looks like you're new here. Sign in to post and engage.