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 have several stacked bar charts due to lack of area graphs. These charts show data over time grouped by a category. The problem is that the user ends up 'approximating' the total of each stacked bar without having an actual total value displayed. Could you please add the ability to add a 'sum total amount' above each…
Would like to be able to have my report view to be exported as shown, including groups, summaries, and filters. Would like this to be true for exporting and sending as an attachment. Reference this thread for additional user feedback. Community Thread
Hello, I am working on a project aiming to calculate the remaining product cost for a list of contracts. I have two columns with data which both have multiple values separated by delimiters and need to add the values in column 1 (quantity shipped) if they match with a specific value from column 2 (dosage). Example Data:…
I am working on some budget tracking. I have a source sheet with each expense account and how much is budgeted for each month (Jan-Dec) and it goes back years. I want to display the info on a graph that show Jan-Dec and the sum of all expense account budgeted amounts in each cell. Right now in my metric sheet I have the…
In Reports, It would be GREAT to be able to right click on a column header and add that column as a group or a summary. The options would be: 1. Group by this Column 2. Summarize this Column And then when you go to the GROUP or SUMMARIES menu, you can then select how you want it summarized or grouped.
It looks like you're new here. Sign in to post and engage.