Best Of
Re: Report not printing as shown on screen
@Janelle Amazing. I stumbled upon this thread while trying to figure out how to print a report that looks like what it shows on the screen. I CANNOT believe how old this thread and how nothing has been done about it. This would be really useful tonight but now I have to spend more time outside of work hours to try and sort out a solution.
HB_admin
Re: Dynamic dropdowns - Waterfall request
+1,000,000 to have Waterfall/Hierarchical/Conditional/Cascading dropdown lists.
Marc Shecter
Cross sheet references not updating
I have 10 sheets which each have multiple cross-sheet references from other sheets. For the past year these sheets have functioned as designed, and all references (Vlookup and Indexmatch) have updated automatically without me having to even look at it. However, I noticed this past week these 10 sheets stopped updating automatically, and only refreshes when I manually open them. Ive tried adding automations (updating a helper column hourly, sending myself hourly refresh emails, and even adding a checkbox column which toggles on and off by the hour), none of which resolved the problem.
Any ideas on the cause of this?
note; these sheets have static rows, while the columns across update per the cross sheet references. No new rows are ever added- and the columns are fixed, with formulae in each column across which should refresh with data as it gets pulled from the reference sheets.
Any advice will be greatly appreciated, as opening these manually to refresh is time consuming and defeats the point.
Thanks!
ErnestVASA
Re: Send Dashboard via email - manually and automated workflow
Scheduled send of a Dashboard in the body of an e-mail
lisamartin1001
Re: Please let Smartsheet work with time
Hello everyone-
Thank you for the continued votes and comments on this topic. We are very interested in this topic and are looking to better understand the various use cases and scenarios that have been added in the comments.
We're collecting volunteers to speak with our product team about your specific needs around using time in Smartsheet. If you're interested, please reply to this message and we'll reach out to you.
Thanks!
Olen Ronning
Re: Old Version MaxIf
I'm having trouble parsing exactly what you want to do - if you want it to automatically fully move (delete the row from one and move it to another) or just be pulled formulaically onto other sheet.
Either way, from your title it sounds like you could make it happen as long as you could make something work like a maxif() formula…
=if(rev@row=max(collect(rev:rev,doc:doc,doc@row)),"this is current","this is old")
seems like it would get the job done for you. Basically, use a max(collect()) to simulate a maxif().
Hopefully that is somewhat helpful…
Jgorsich
User types and true-up page - show all users
Greeting,
After moving to the new license model (User Subscription Model) and having to use the 'User types and true-up' page for managing the users I find this page is not very user friendly at the moment. Below some options which would be helpful:
1. There is no option to go to a certain page, there are no clickable page numbers showing. With over 2000 users you have to go page by page which is very time consuming and not user friendly.
2. Sorting only works on active overview of 20 users. This should work on the whole list of users.
3. Ability to show more items on 1 page (items per page drop-down).
Serge van Elk
Add Direct Links & Context to Update Request Notifications to Sender
There is the need of having accessible URLs in the notification the sender get, once their update
request has been updated.
But there is hardly any reference to find in the notification emails, thus receiving multiple update confirmations remains hard to understand which user updated what in large sheets with multiple update request usually pending for same rows (but different cells).
These numbered points below refer to the image and show where the improvements in which way would help.
1. The reply does not contain any reference to the message of the update request. If we have sent more than one update request for a row, it is no longer possible to determine which update request was responded to/replied to (unless we use highlighting changes & cell history of each affected cell).
2. The selected fields (in the update request) should always be displayed in the reply to the sender, regardless of whether something has changed or not. (The additional information for the person to update helps also the original sender to get the context once the update is submitted).
3. If cell contents are changed, the line is displayed in the email, but without a link. If the row number has changed in the meanwhile, it is difficult to find the row.
Jean Egi
Re: Automation no longer working
Hi @ljkeefe1,
I've had similar issues a couple of times. First time was when we changed our email scanning provider, and I had to change my settings to allow the mail to get through.
Second time, I ended up deleting and re-adding the workflow. Not ideal I grant you, but it's been working so far..
(cue me raising a support ticket tomorrow).
Do you receive the email if you run a test on a specific row? I have a workflow that send to two addresses, my email received them, a shared mailbox didn't. If I ran the test on a specific line, both accounts received it.
Bets of luck
PM_Reeves
Community Signature Visible on Mobile Phones
Dear Community Members,
I recently noticed that Community Member signature is only visible in the posts opened on PC / MAC browser but not on the mobile phones.
as an active member of Community and Smartsheet Partner I would like my signature to be visible. I asked Smartsheet about it and they told me to open the post in this section so other members can contribute on this idea as well.
It's a a setting that Smartsheet will turn on if we decide we want it :)
So who is in?I?
kowal