Best Of
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
Re: how do I put created date column values from Excel into Smartsheet column type created date column?
No. You'll have to use a column called Created Date and just have it set to a date type. Then you'll need to create an automation for when a new row is added to add a date to your Created Date column.
I agree that this isn't the best way to go about this so I'd suggest submitting an Enhancement Request to SmartSheet to see if they can add a feature to the Import Excel File sheet creation that would take any column in the Excel file called Created Date and feed those dates into the system generated Created Date column type. While you're at it, suggest that they allow the Created Date column to have it's date formatting changed because currently they do not allow that.
Mike TV
Re: Copy/Paste Permission Issue
My columns/types all match. I am the owner of both sheets, but I'm still getting the permission error.
KatherineS
Re: We need the Owner (or Creator) back
100% agree. Need this back ASAP, it is hindering work.
Sara_Cook
Re: We need the Owner (or Creator) back
Maddy.craytor's comment is most aligned with how my team and I had used the "owner" column. The idea of moving away from individual ownership to workspace owners is fine. For all intents and purposes, however, the owner column was synonymous with creator. There were certainly times when ownership changed but assets are predominantly owned by the creator and knowing who created an asset in a workspace with multiple administrators/lots of items is extremely helpful.
Delta615
Re: How to use index, collect, contains
Create a helper column on the PO sheet to extract the 12345 from the PO number. Then Index Match to the helper column
=VALUE(IFERROR(LEFT(PO@row, FIND("-", PO@row) - 1), PO@row))
dojones
Re: Populating a drop down from data in another sheet
You have to populate it. Theres a long standing enhancement request for Smartsheet to provide a way to populate a dropdown through a reference, search and vote it if you like, but for now the only option is to populate the array of choices.
Brian_Richardson
