Best Of
Re: February Question of the Month - Join the conversation and receive a badge
I think a Published Performer badge for users who create published reports, dashboards, sheets, etc., and a Distinguished Dashboarder badge for users who create dashboards. You could award it by request or by how many dashboards and published pages they are admin or owners of.
Amanda Winter
Re: February Question of the Month - Join the conversation and receive a badge
The newest badge I would like to earn is the Quarterly Topic. It would be the culmination of the discussion and deep dive into features of Smartsheet over the course of a quarter. The Badge(s) would be Q1, Q2, Q3 and Q4 for Beginner, Intermediate, Expert and EAP levels.
Some Examples:
Beginner - Basic Sheets, Beginning Formulas, Beginning Automation
Intermediate - Dashboards, Advanced Formulas, Advanced Automation
LeiLeni Parks
Re: Deactivate form after set # of entries/submissions OR by date
I would love to have the ability to deactivate the form after a specific number of entries. We use forms for event management and have limited space. It would be extremely helpful if the form could be deactivated automatically after a certain number of entries.
jd4cu
Re: February Question of the Month - Join the conversation and receive a badge
I'd love to see a Smartsheet Mentor badge, with nominations similar to the Peak Human badge process.
ss_innovation
Re: Is there a way to generate an alert/block on Smartsheet, in case a schedule causes overallocation?
Hi Isaac, thank you so much for your detailed guide, I will try it!
hilalt
Re: Smartsheet User Groups - Sign Up Today!
Hi Angie! We're working on adding more virtual sessions to the calendarโstay tuned! We're also exploring future locations, possibly in Florida!
Kelsey Hayden
Re: Sheet Summary with combined date fields
If your dates are in date format columns you could try the DATEONLY function.
=DATEONLY([Start Date]#) + " - " + DATEONLY([End Date]#)
If they are text you can use the LEFT function to return only the first 8 characters.
=LEFT([Start Date]#, 8) + " - " + LEFT([End Date]#, 8)
KPH
Re: Data Shuttle: Missing Rows/Entries
This isn't a fix, more of a workaround but you can change your data shuttle to inly add and update, instead of add, update and delete so if the new data isn't there you just keep the old data and then when you turn on highlight changes you'll see which unique ID's didn't change and therefore don't have stats for that month
alyssad
Re: Report not updating formula unless the underlying sheet is opened and "refreshed"?
@James Keuning, I had a similar problem with the RGYB symbols not updating for reports unless the sheet had been opened. Although some users suggested adding a date to helper column and running an automation to update the date every night, this threw off my "Date of Last Activity" variable by making it look like every project had been opened every day.
@Ryan Sides (giving credit where credit is due) mentioned he had noticed toggling the Lock Row variable does not effect the auto populated "Last Modified On" column and suggested I try toggling the Lock/Unlock through a nightly workflow... it solved my problem wonderfully. No Helper sheet needed, no other dates getting interfered with, no changes to my sheets when it is completed.
Here's a screen grab with an example of the automation I now put into all my templates. Try it and see if it helps solve your TODAY() function issue... and please let us know!
Andrew Stills
Re: February Question of the Month - Join the conversation and receive a badge
Workflow Wizard - for those who assist other users in troubleshooting automation workflows.
JGrison