Best Of
Re: Introducing the newest Community Champions! 🏆 [January 2025]
Congrats everyone!!! 😀 Looking forward to meeting you at ENGAGE 2025!!! 🤩
Chizu Hieida
Re: Index Look Up - Help a Newbie?
that worked - i really appreciate you taking the time to answer this!
BrookeDawn
Re: Data Shuttle - Notifications if Unique ID is Missing?
@Samuel Mueller great idea! I love when a solution is simple haha. Thank you!!
RAdamowicz
Re: Form for evaluation
Using a form, you would need to set it up on a separate sheet. You can then use a formula to create a hyperlink to the form with pre-populated fields (there are a number of threads on URL Queries here in the Community to help you get started with that). One of those fields should be some sort of unique ID for the row. You would set up an alert on the main sheet to send them the link generated by the formula.
Also in this main sheet would be the answer columns and each would have formulas with cross sheet references such as INDEX/MATCH to pull the form responses back over into your main sheet.
Paul Newcome
Re: Can a SysAdmin transfer ownership of a WorkApp
Hi @io_DR
You can contact Support to help with the transfer if the user has already been deactivated. Please see the steps in the Help Article linked above:
Cheers,
Genevieve
Genevieve P.
Re: February Question of the Month - Join the conversation and receive a badge
Not great at coming up with clever names, but a series of badges recognizing proficiency with premium apps might be nice.
jessica.smith
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