Best Of
Re: Canada in Form Phone Validation
Please make the Canadian flag visible on live forms so we don't have to add an explanation about it to our Canadian Members.
JennTaylor
Return Row ID / Row link in cell?
Hi all,
Looking to leverage a function that clearly exists in Smartsheet, but doesn't appear to be a user-side feature:
Application:
I have a report with two sources. Essentially one is an intake log generating new 'Change Request' UIDs, whereas the second source is approved requests which are given 'Change Order' UIDs. I have an index(collect()) column formula in both sheets that allows us to cross-reference the UIDs.
Problem with current state:
Currently the UIDs are hyperlinks where they are the source sheet, but text only for the index(collect()) reference. Users have to find the order, see the UID for the request, then go navigate to the request in the report, then follow that hyperlink to the source sheet, or manually look this up directly in the source sheet.
Returning a hyperlink for the indirect reference would streamline navigation considerably since we're dealing with a high volume of records.
Request:
Address to the row link or row ID property via some formula / function in a cell so that cell value can be displayed via index(collect()) in locations where this row is relevant, but indirect.
Feels like this should just be a standard shell function =@rowID or =@rowlink
Evidence:
In properties, each row in a sheet has a unique Row ID and Row Link.
When I run a report, the native 'Sheet Name' column displays a hyperlink that is not only to the source sheet, but directly to the sheet row from which the report is pulling. I assume this is addressing to the Row Link.
I've seen some threads suggesting to manually copy the row link to a cell on that row, which would technically work, but is absolutely not scalable or automated and therefore a no-go.
Thanks in advance for any ideas / suggestions!
Rob W.
Include Comments Tick Box in Card View Settings
Would it be possible to add a show/hide option for comments in the card view settings?
While I appreciate the customization options for displaying information, having the ability to remove the comment icon would enhance visibility by freeing up valuable space in the lane. This small change would improve the aesthetics and effectiveness of displaying a large project.
Laura Ablasser
AI writing details of a task in another column
Smartsheet is arriving with some delay in the use of AI while Monday.com has had this service for some time. One basic thing is the possibility of AI writing details of a task in another column based on the information contained in the task.
Another thing: Is there any plan for Smartsheet to eliminate this need for us to keep SAVING the spreadsheet after editing it? This delay is a problem because sometimes we lose updates or changes to the rows because we forget to update. Other online applications have already eliminated this a long time ago.
Finally, we need to speed up the process of improving aesthetics and user experience because this is something that has been considered by people who are switching from Smartsheet to other platforms, such as Monday.com itself and others.
My goal here is to collaborate. I would be grateful for any feedback on these suggestions. Thank you.
fvagner
Re: Dynamic View - Conditional Formatting in Blank Cells
This is concerning as we rely on Dynamic Views to build our user interfaces. We recently demo'd a new feature using conditional formatting which was greatly received by our user community, but now, we hit this bug in testing.
Please prioritize this fix.
huntergammon
Re: Dynamic View - Conditional Formatting in Blank Cells
I've experienced the same issue, conditional formatting does not function correctly in dynamic views, but is correct at sheet level and in reports. Please fix this bug.
Julie T
Re: VLOOKUP's don't update in background anymore?!
hi @Jesse G.,
This is now the third post about the index/match or vlookup that stopped working recently despite working for months or years.
Did you contact the support already on that it seemed like smartsheet made some changes in the last week or 2 and all of those stopped working.
kowal
Re: Edit reports on a dashboard
yes, to edit reports on a dashboard would be very helpful…thank you.
Penny_E
protected / limited filter by user
Our company has been using Smartsheet since 2017, and I really appreciate it. However, due to the inability to protect filters (restrict what a user can see on a sheet), we will have to look for another solution this fall. I submitted this suggestion several years ago, but unfortunately, it was not addressed. It's a shame because Smartsheet is very user-friendly and efficient.
Jack_rox
“form response email” would also include the “Headers”
I would like to request that the “form response email” would also include the “Headers” sections as these can contain important information and links. Yielding to when end user completes the form and checks the "send me a copy of my response" option, those answers are sent to their email.
magsean