Best Of
Re: How to get Join Collect formula to work
Hey @Dakjoekipe
Try this:
=JOIN(COLLECT(Task:Task, [Predecessor Helper]:[Predecessor Helper], CONTAINS([Row # Helper]@row, @cell)), " , ")
The " ," at the end is the delimiter - the separator between textstrings so it doesn't run all together. If you don't want this, you can delete all the entries and have all three closing parentheses stacked all together. If instead of a comma and spaces between entries, let me know if you would rather have it as line breaks.
Will the formula work for you?
Kelly
Kelly Moore
Re: Report Tasks within this week
The easiest method is to use the Filter option in the report, "Is in the next", and put the number of days, 7 for example, to capture tasks that are coming due in the next 7 days.
If you need it to be this week or next week, create helper columns to identify when this week and next week ends and then compare the task date to those dates.
dojones
Use generic name for Smartsheet automated notifications that can be easily updated
When I have changes in a number of Smartsheets due to personnel changes (terminations, new hires, promotions) I have to go through a large number of sheets to change the destination address for the notifications. For example, Kathy might be my accounts receivable person. When she changes roles, I need to change the notifications to a new person. I'd like to put in an Accounts_Receivable placeholder that when the role changes, I can put in a new person to that placeholder and not have to change all the automations. I'd also like to have the option to have the accounting manager get all the Accounts_Receivable notifications. I recommend that we can make a placeholder work globally throughout my company or be specific to a sheet.
John McAlonan
Min - Max Durations on Gantt Schedules
It would be very helpful to input a minimum and maximum duration for an item and have the color bar shown with two tones. This would enable us to see where optimization is possible while still planning conservatively, or vice versa. There would need to be a setting for where to connect to the next item, i.e. minimum (best case), min+, average, max-, maximum (worst case).
NateHauk
Option to enforce "Unique"column, similar to a Primary key value in a sheet
Missing basic feature in smartsheet.
Copied from :
real.ChaM
Auto refresh dropdown list values
When creating a droplist list column it will auto populate with values already in the column whether in the same sheet or sourced from another sheet. However, after the dropdown list does not change thereafter. Most of the requests to auto refresh dropdown lists and use them in forms arise due to the inability of the dropdown list to be automatically updated. While this can be achieved with the premium data shuttle app and multiple third party products it should be a native Smartsheet function and it's absence is a major shortcoming.
WGTP
Re: Provide users with the ability to Print a Grouped Report
Since this request to give us the ability to print a reports isn't happening anytime soon, would it help if I said "Pretty Please with a Cherry on Top"? Also, Happy Belated Birthday to this enhancement request. It is two at least years old now. The original request is over 3+ years.
XR_Tech404
Can an automated email with an attachment be sent without link to the sheet
Tried to search but all the responses are old and I'm hoping that Smartsheet's has made an update.
Can you send an attachment on an automated email through workflow without linking to the sheet???
Connie Cochran
Dynamic View - Search function/Ctrl F
Wondering if anyone else is having issues with a Dynamic view only being able to search fields that is current on a view in Dynamic View. IE, if line 1 has "Michael 1234", and you scroll down so "Michael 1234" is no longer in view, a Ctrl F does not find that row/cell. Wondering if anyone else has this issue; and if there is a work around that anyone can share.
Mtmoroni
