Best Of
Re: Index-Collect
Try this:
=IF(CONTAINS("TBD", COLLECT([Task Date]:[Task Date], [Feature]:[Feature], [Feature]@row)), "TBD", IF(CONTAINS("DFD", COLLECT([Task Date]:[Task Date], [Feature]:[Feature], [Feature]@row)), INDEX(COLLECT([Task Date]:[Task Date], [Feature]:[Feature], [Feature]@row, [Task Date]:[Task Date], CONTAINS("DFD", @cell)), 1), MAX(COLLECT([Task Date]:[Task Date], [Feature]:[Feature], [Feature]@row))))
Paul Newcome
Re: COUNTIF and HAS calculations
Oh man, stupid mistake of over parathesis-ing on my part from copying and pasting. Remove the parenthesis that comes before the last two HAS, like:
=COUNTIFS({Sabre Traveler Care Priorities Range 5}, HAS(@cell, "NDC"), {Sabre Traveler Care Priorities Range 4}, OR(HAS(@cell, [Primary Column]2), HAS(@cell, [Primary Column]3), HAS(@cell, [Primary Column]4)))
AKnight
Re: Celebrating the women of Smartsheet Community
Hey hey! I'm loving this thread, and all the awesome women in the Member Sport Light!
As you mentioned, this year, I asked our Costa Rica employees to nominate the “Super Women at Smartsheet” the response was overwhelming! We are surrounded by women who inspire, lead, uplift, and drive impact in countless ways.
I'd like to share one of the nominees here, @Rebeca S. who truly is a Community Super Hero!
Marcela
Re: Conditional formatting to enforce not bold
If I had a nickel for every time Andree has started an answer with "Unfortunately…" about something basic Smartsheet cannot do, I'd be a millionaire.
bkw1962
Re: Why won't certain columns appear when I try to group them in a report
I hope you're well and safe!
If the columns are multi-select, it's impossible to use the Grouping feature.
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å
Why won't certain columns appear when I try to group them in a report
Hi all I am trying to group the report by certain columns only when I go in to add columns they do not appear. The specific ones not showing up are the "Assigned To", Objective" and Quarter Columns. Anyone have ideas on how this can be resolved. Thank you.
jordan_manor
Re: report not showing all columns from a sheet
I'm having a similar issue, but there is only one sheet, and the column I'm trying to pull is not my primary column. I did see it previously, but created a new report, and it's no longer an option.
The column is an email address, column type Contact list. When I was able to see it, I could select the column, but "has all of" wasn't an option in the Summarize dropdown. I need that so I can restrict visibility to the current user. Do you know why it wouldn't show up?
Thanks!
Stephanie B.
Highlighting results from a search for easier and faster visual process
The search function is hard to see when searching a smartsheet database. It only outlines the cell with a light blue border. This is a request to allow users to have search results highlighted in a color of choice for easier and faster experience when conducting key word searching in large databases.
anna1234
Automation Request: move rows to the bottom of the same sheet
Please allow smartsheets to move a row to the bottom of the page when you click the check mark. Like a todo list. When you click the check mark it moves the row to the bottom of the list and the incomplete items are left at the top of the list.
CandiceM.
Re: Saving a "Form" for later use without submitting as of yet
I discovered on a mobile device you can save a draft form and come back to complete later. This should be the same with the desktop or online version. Having the ability to save allows for more complex uses of the Forms function.
BKsmartsheet