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 several reports I've created I need to get an accurate count of checked checkboxes within the summary section of the report, and currently, the summary is counting all checkboxes- whether they are checked or not. The image below shows that it's counting 4 checkboxes, but it should only be three since that's the total…
Hello, I have a process set up where I pull data in from another sheet, and then I have a handful of Columns with formulas that will fill with a Check or Uncheck based on the information in the data that was pulled in. My goal was to be able to use these Checkbox columns to track processes, but since the columns are locked…
I have a sheet, that no matter how many times I change a Column Type to Check Box, it reverts back to Dropdown list. What could be the source of the issue? I can't find any automations or Data Shuttle items that would even reference this sheet. This column is a formula that is referencing a check box on another sheet, so…
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…
Hello, I am having a bit of difficulty expanding an IF formula to include a value that is in another column. Let me give an example https://app.smartsheet.com/workspaces/GJqhP3jxmV78WQfw4mc3c6PXH3WqPJcjM2c3Frh1 In this mock workspace I have created basically what I'm doing and what I would like to happen. (all names and ID…
Hello community, I have troubles with one of the checkboxes in my Smartsheet. As you can see (in the highlighted colum) some of the fields show checkboxes, whereas others show yes/no. When I double-click on e.g. Yes it changes to a ticked checkbox. I already tried deleting this whole column and adding it again, but this…
Need help with syntax for a formula for counts. Goal: Give a count where If STATUS field contains string value "new" and where a checkbox named External is checked. Formula: =COUNTIFS(Status:Status, "New", [External:External, "True"]) Currently getting an error: #UNPARSEABLE
I use the Smartsheet connector in Power BI. I have a "Closed" field in Smartsheet, it's a checkbox. Check it when a record is closed. Then in my Power BI dashboard I have a filter. It shows active records when Closed is FALSE and inactive records when Closed is TRUE. Well today a user told me that he reactivated a record…
It looks like you're new here. Sign in to post and engage.