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…
We are using HeroCoders Checklists in our Jira. When I create a query in Jira I am able to add the Checklist Text column to the results table. I would like to use Jira Connector to sync that data into a Smartsheet. When I try and setup the Workflow, I do not see this in the add field list. Has anyone tried to do this…
Hello - we are having problems adjusting a formula to include additional details. The formula is being used on a sheet for a project checklist. The parent formula shows the overall status of child tasks - if they are all "Completed" then the formula should say "Completed", if they all say "Not Started" then the formula…
I would like to have a cell either be blank or have a checkbox if another cell is blank/notblank. Basically I want to have something like: =IF(ISNOTBLANK(Monday@row) = Create Check box Otherwise leave cell blank. Is this possible?
Hi I like that we have subtasks that can have as many rows as we need. Sometimes though we need something like a checklist with radio buttons to mark off activities on a row that means we can limit the number of rows being used. For example a row might have research online channels for topic and the checklist only needs to…
It looks like you're new here. Sign in to post and engage.