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…
For progress column, I want to use the symbol column with bar option (Empty, Quarter, Half, Three Quarter, Full) and it should be driven by task % Complete. if % Complete Value is 0% then progress should be Empty, if complete value is between 0 - 35% then progress should be Quarter, if value is between 36-65% then progress…
Hi all, I am trying to have the symbol color change based on the % Complete on a task. I have gotten it to work for 3 colors (Red/Yellow/Green) in another sheet, but now I am trying to do the same with 4 colors, including Blue. I am looking to have symbol turn Green when % Complete is at 100%, Yellow when % Complete is…
Dear Community, I noticed that in the BoardView or CardView the names of the columns are not visible which make our cards very unreadable… is this on purpose or I am missing something? Those blue dots are symbols columns but now useless without the Name of what they represent.
Currently, there is no ability to change any of the symbol size. I have a requirement to use Harvey balls on a dashboard (nothing other option). However, because the size is not customizable Smartsheet is not a good solution for what we need.
I always put an underscore _ before a workspace name if I want it sorted first in my Workspaces list. (eg. _Workspace1). But what if I wanted to place something before my __Workspace1 workspace, without worrying about the alphabetical order? Most software will sort things based on symbols then numbers then letters, and the…
It looks like you're new here. Sign in to post and engage.