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…
Hi Guys, Created a basic script to download all PDFs from a sheet. Use case: I use Document Builder to create documents from field inspections. However, we need to store these in sharepoint for redundancy. This script basically pulls all "PDFs" so you can then migrate them where you need to. I don't want to pay an…
I was trying to use the Scheduling: Create Workflow Schedule module in Bridge to set up a 60-minute timer that would alert our team if another workflow didn’t complete within that window. I was struggling with how to pass and access state values between the workflows. After working with a Pro Desk support agent, we figured…
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() -…
I would love to be able to take action within a formula based upon which specific error the formula spits out. Right now, the IFERROR function catches errors but doesn't tell us what kind of error it is. It would be great if we could recognize different errors like #BLOCKED, #UNPARSEABLE, #DIVIDE BY ZERO, and others.…
I have columns that are set to take certain types of data, and they contain formulas that fill the cells with values permissible within that data type. For instance, there's a field where a formula fills in one of several options based on a cell reference, or the user can manually select one of the options from a dropdown…
The error message is that the syntax is not right. =IFERROR(NETWORKDAY([Date of Visit]1, Created1) - 1, "Need Data") I've always gotten such great support here. I appreciate any help. Best, Craig
This formula is producing syntax error when I try to make the column a "column formula". Is there a workaround? As we add new Rows (copied from different sheet), I want all values in Client Name column to equal Task column Row 1.
It looks like you're new here. Sign in to post and engage.