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…
Hello, I am not able to sort a count column numerically from largest to smallest. In this project, I am grouping departments to measure how many departments submit the most requests. I am able to group the departments by name, and summarize the departments by count. However, the report will only sort the columns by the…
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
When I try to group by the priority (high, medium, low) it will not allow me to sort them in high medium and low, it is sorting them alphabetically. Has anyone found a way to optimize this so that I can group my projects by priority and see them in high - medium - low order?
Hi there I have a large sheet that i have used the "group By" function to collate by a particular column fields - when i add a dynamic view to make this sheet editable on a Dashboard it loses the groups and reverts to an ungrouped Sheet view - any thoughts ? Help appreciated :-) Trying to reduce clicks one day at a time…
Hi - curious if anyone else has ever come across this - not sure if it's an issue or if it's something in the configuration that I am doing wrong. We have a control center solution that uses Dynamic Report scope to add the reports for newly provisioned items into a blueprint-level summary report. We have them grouped by…
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.