Best Of
Re: I keep on getting an error that says that my formula contains a maximum number of different cross r
Hello @Nonkululeko
Changing the function will not help remove that error.
Your function is also adding ranges. I do not believe you can add ranges together without another function to analyze them like COUNT() or MAX()/MIN(). Correct me if I'm wrong.
The issue is that there are too many cross references into the sheet itself. You will need to consolidate the data further before using cross references or split the data into multiple sheets.
MichaelTCA
Re: best way to convert excel tracker to smartsheet
@SteCoxy not a bad idea and probably makes sense. Will give it a go actually… thank you
MazU
Re: How do I customize a request ID based on specific form selections?
Hey @Kelsee Katsanes,
I don't know if there's necessarily a way you can have each form selection have it's own count (ie if there's one submission for Content Management then another for QA, they would each start counting at 1), as there's no way to use a formula with the Auto-Numbering column, and you can't have more than 1 Auto-Number column per sheet.
What you could do is use the Auto-Numbering column as a helper column (with it having whatever auto-number settings you want), hide it, then have an actual Request ID column that joins the auto-number column and the dropdown selection:
=IF(Department@row = "Content Management", "CM" + [Request ID]@row, IF(Department@row = "Quality Assurance", "QA" + [Request ID]@row))
And use this for your actual used Request ID column.
Hope this helps!
bisaacs
Re: Nominate Peak Humans & get a badge!
I nominate the following
@Paul Newcome's knowledge of Smartsheet is top notch. His willingness to share that knowledge with those of the community never ceases to amaze me. He has assisted in a couple of solutions for myself. As well as his knowledge has showed up more times then I can count during research into any problem.
@Clare Cooper has shared her knowledge with me above and beyond what I would expect. More then once spending an Hour+ helping me with different formulas and functions needed to be able to achieve reports and dashboards.
Thank you both for all you do and have done.
Mark.poole
Re: How to Track Child (Level 2) Completed Rows Over Time?
To remove the Invalid data try modifying your formula to this:
=IF(ISDATE([your completed date]@row), YEAR([your completed date]@row)+"-"+MONTH([your completed date]@row))
On your report also add another condition to your filter that Year-Month column is not blank.
I'll have to think some on your cumulative number.
Kelly
Kelly Moore
Re: Is it possible to send reminders to email addresses collected by form submission from non users?
@Will Jeffords Haha, I can totally relate. Whether it's figuring out how to answer a question or ensuing conversation, I love this aspect of the Smartsheet community pages.
To address your privacy concerns, it only has the "Contact" column as a dropdown in the form if you've put in contacts in the "add contacts" section of the column setup. Otherwise, the field in the form remains blank. Also, even if you have contacts in that section, it will only display the contacts you have added there as options, not any other inputs in the sheet. In the screenshots below is an example of a column that has multiple emails in various cells but only one dropdown contact added. Then, the second screenshot is a sample form with two contact fields, "Email/Contact" is the column referenced above and the "Contact" field has no contacts added as options, so that you can see how they represent themselves differently in the form.
Hope this helps!:)
brianschmidt
NEW! Timeline view
Hi Community,
The all-new timeline view is here! It lets you seamlessly arrange work on a horizontal timeline and group tasks to easily track project progress, collaborate in real-time, and communicate statuses with stakeholders.
Log in and switch to timeline view to:
- Create and share project roadmaps for easier cross-team collaboration
- Manage large portfolios while also reviewing tasks at a granular level
- Map out advertising campaigns, event logistics, marketing material development, and more
Licensed users on business plans and above can create and share in timeline view. Timeline view can be accessed in any sheet (with at least two date columns) from the existing layout switcher.
Our journey with timeline is just beginning, and more exciting capabilities are on the horizon. Today, you can fully take advantage of the benefits of timeline in your sheets. Our next step will empower you to publish timelines seamlessly in your dashboards and integrate timelines into your reports.
Learn more about timeline view.
You can also stay informed by subscribing to receive product release updates for curated news of recently released product capabilities and enhancements, delivered to your inbox every Tuesday.
Thank you!
Elektra Helde | She/Her | Product Marketing
elektra_h
Re: Used Save as New to Open a new Project Sheet - Contact List not functioning right
We solved it ourselves by unchecking "Restrict to List Values". We can now access the full contact list and the @mention functionality works.
MarianneD617
Re: Arrows in a text row with other text.
Hi,
I hope you're well and safe!
To add to Brandan's excellent advice/answer.
You can also use Emojis.
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
Andrée Starå
Re: How to match clinical trials to subjects based on eligibility criteria columns?
Hey @S_Berkley
You're very close! Instead of using CONTAINS, since you're looking in a Multi-Select cell I would suggest using HAS instead.
In either CONTAINS or HAS, we'll want to use @cell instead of {the range again}. This is because we're looking into each individual cell of the previously stated range.
Try this:
=JOIN(COLLECT({Study Name}, {Cancer Type}, HAS(@cell, [Cancer Type]@row)), ", ")
Let me know if that worked for you.
Cheers,
Genevieve
Genevieve P.
