Best Of
List of column names?
This might be a long shot but does anyone know if there is a way to get a list of all of the column names? We have a sheet that has over 100 columns and I would love to get some kind of vertical list that has them all listed so I can review them and their order...without having to scroll horizontally and getting confused. Thanks!
laura.sandoval
Re: Using a Form for a Check-in/out build.
Hello @Ty Werven,
First, you can use form logic to show/hide fields in your form. See here for more info.
To show the number of visitors in the Room you can indeed use a metrics Sheet and a cross sheet formula to count the number of rows where someone is checked in for the current room. Note that your dashboard will only update when you refresh it/it auto refreshes.
You can set up a move row automation that will send a row to a Sheet of your choosing (i.e., "Trash Sheet") whenever someone checks out.
Hope that helps!
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
