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 am trying to use the Row ID numbers for a formula but can't figure out if that is possible. Do I need a helper column?
Hello, So to be able to do this so far I have added a helper column to my main smartsheet. This column I called "Days Between" just counts the amount of days between column Referral Faxed Date and Eval Date. Helper column code: =([EVAL DATE]@row - [REFERRAL FAXED DATE]@row ) This seems to be working fine but we don't…
I can't be the only person that is VERY bothered by having the formula editing bar in the SAME row as the row you're applying it to? It drives me nuts when I try to type in a formula and the editing window COMPLETELY COVERS the entire row, so I cannot see the columns/cells that the formula is referencing, nor can I click…
It looks like you're new here. Sign in to post and engage.