Best Of
Re: Welcome to the ENGAGE Guestbook: Share & Enter to Win!
This is my 2nd Engage! I look forward to making even more connections with new friends/ Smartsheet users and learning how they're using it for their work.
Re: Filtering values from collection file
Hey @Charles9937, unfortunately Smartsheet doesn't have "dynamic dropdowns" so you would need to use the form logic and manually put in all the dynamic choices (and each one would need it's own column). The closest thing I have found to a workaround for this is to use a different application for the form, then a web-connection app to send the results into Smartsheet. Hoping this will be a new feature soon!
jjg279
Swag
I wore a Smartsheet branded tshirt out and about this week and was randomly stopped by someone who engaged in conversation about the platform and using it at their daily job. How cool! Anyone know where to get a sweater or cooler weather gear so we can rep during these colder months? Got my shirt at an event a few months back!
Szwedaj
Re: Now Announcing - Linked Dropdown Columns!
It will remain linked even if you switch back into grid view!
Danielle Wilson
Re: New to Smartsheet and completely overwhelmed - how do I manage trials with multiple tasks?
In general when setting something up like this you want to start at the easiest version possible and then make it more complex.
So - the easiest version possible is going to be a simple list (start with a Grid view, call this sheet "Main") where you have 1 column each for Location, Variety, and Date planted. This information will always be unique to every individual trial. Fill in 10 or so with fake (or real) data covering a few different varieties and dates so you can test as you go.
Now, you ALSO want to track Crop, growing days, and expected date harvest (I'd consider adding actual date harvested and a notes column at a minimum), so go ahead and make columns for those but don't put any data in yet.
I'd assume that for any given variety the crop is fixed (that is, you don't have two varieties named the same thing that are two different crops). If that is true, on a DIFFERENT sheet (again, Grid view, call this sheet "Reference") you can have a column for Variety, Crop, and Growing days. Fill that data in for all your varieties.
Back on "Main", you can now fill your Crop and Growing Days columns using cross sheet references and index(match()) formulas (you can find lots of explanations on both by searching through old replies here). Your expected harvest data column would just be filled with a simple formula like =[Date Planted]@row + [Growing Days]@row.
Of course, there are also lots of consulting firms that can help you set this up as well, but hopefully that gets you started!
Jgorsich
Re: Adding cells with IFERROR blanks
Debbie,
Access approved, thank you for taking a look!
EDIT: You were correct, I just needed to add the IF(ISBLANK()) in front of the cell causing the issue in the addition formula. I tried that before, but wasn't using it incorrectly!
Thanks for the help.
Jaymon
Re: Welcome to the ENGAGE Guestbook: Share & Enter to Win!
I absolutely left with a smile on my face after hearing guest Ted Talk speaker Shawn Achor! So many great Smartsheet speakers filling my brain with ideas!
April MacLennan
Re: Welcome to the ENGAGE Guestbook: Share & Enter to Win!
This is my first ENGAGE. So far so good!!
Vsweerts
Welcome to the ENGAGE Guestbook: Share & Enter to Win!
Hey there, ENGAGE attendees!
We hope you're having the best time at the conference. We'd love for you to take a moment to sign our virtual ENGAGE guestbook. ๐
This gives you a chance to win one of the cool gift baskets, filled with Smartsheet swag and products from local businesses.
Want one? Participate by telling us:
Whatโs an ENGAGE highlight youโve experienced or are lookingย forward toโ whether it's meeting a certain person, an announcement, an activity, or something else - we want to know?"
Note: By participating and adding your comments below, all ENGAGE attendees will be entered to win one of the 4 gift baskets. If you win, the Community team will contact you via the ENGAGE app and through email. All prizes must be claimed by end of day Thursday, at the Community booth.
Official rules can be found here.
Rebeca S.
Re: Access to the Dynamic View
@Charles9937 Below is a suggestion.
1) In Smartsheet Form Settings, disable "Allow submitter to email a copy of form submission".
2) Create an Automated Notification to Sender with a customized message that includes the link to the Dynamic View. This should be triggered by a new submission.
