Best Of

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

1 ·

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:

https://help.smartsheet.com/articles/2482208-transfer-workapp-ownership?#RequestTransfer

Cheers,
Genevieve

Genevieve P.

1 ·

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

1 ·

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

2 ·

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

1 ·

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.