Best Of
Re: Collect Multiple Row Data into a Single Cell Reference
Hi @KThordarson,
This should give what you are after.
=JOIN(COLLECT({PTO}, {Name}, HAS(Attendees@row, @cell)), " , ")
Hope this helps,
Dave
DKazatsky2
Re: Smartsheet Forward Q2 2024: New ways to unlock actionable insights
Thanks for sharing Ben, these enhancements are really exciting! The AI integration is cutting-edge and that new timeline view looks really clean.
Will Duplex
Re: Internal Smartsheet Department
Thanks @A.J.
That makes a lot of sense and sounds like a good place for us to start.
Isis Taylor
Smartsheet Doc / Page / Wiki
It would be so awesome to have a "Dropbox Paper" or "Notion.so" type of markdown doc in smartsheet. Not all information should be on a sheet.
The combination of a wiki markdown page + sheets would mean that much more work could live in smartsheet instead of having to bounce between multiple tools.
The main issue with multiple tools is data integrity. Having all that data linked inside smarsheet would be ideal.
Adding this to the "create" drop down would be the ideal UX.
Joseph Estes
Re: Introduce yourself & get to know your peers!
Hello,
I'm Nicolas, from the South-East of France. I'm learning to use SMARTSHEET for 2 weeks. This is my first comment in this comunnity. I will first look for information. Thanks to be part of this community.
Nicolas Goulinet
Re: Introduce yourself & get to know your peers!
Greetings and Salutations!
Laurie Schroeder, PMP coming to you from the 'Biggest Little City', Reno, NV! Hello my fellow SMARTSHEETers!!
I currently work for a credit union which is a first for me, my background has been mainly in healthcare. I love SMARTSHEET and have used it for so many things. Projects, Project Portfolios, various signups and forms, COVID resources, inventory, service desk ticketing, you name it and SMARTSHEET can be used.
I have also managed an instance of SMARTSHEET so familiar from a user or admin perspective. I'm amazed at the growth SMARTSHEET has had over the last several years. AMAZING!
lschroeder
Re: Provide users with the ability to Print a Grouped Report
Printing a dashboard is definetely not an option :
We deserve something workable !
By the way, 200% is the maximum allowed scale.
benoit.stalder
Re: IF Formula
Hi @jcaguioa
Thanks for the input. It works so far for the testing file. Will map the formula to our original file. Thanks so much for your advise.
HZAR
Re: Get your Brandfolder Badge 😎
I love Brandfolder. I am interested in the connection with Smartsheet. Organization can be able to manage all activities like structured project work and sometimes unstructured creative work also. Fantastic !
Re: Is it possible to evaluate multiple predecessors and match to a cell value in another column?
I've done something similar, and depending on how simple your predecessors are, the solution could be simple, or make your head spin. For the super simple version (2 predecessors MAX) try this:
Add "Row #" column to make sure your lookups match your Predecessor numbers. This formula will match if you shift rows around and such:
=MATCH([Work Order]@row, [Work Order]:[Work Order], 0)
You must break out the Predecessors into individual columns. I can't seem to change them to values referencing the Predecessors column directly:
Pred#1: =IFERROR(LEFT(Predecessors@row, FIND(",", Predecessors@row) - 1), Predecessors@row)
Pred#2: =IF(FIND(",", Predecessors@row) > 0, RIGHT(Predecessors@row, LEN(Predecessors@row) - FIND(",", Predecessors@row)), "")
Then you can use those values to bring in the corresponding work orders with an INDEX(MATCH()) combination.
=IFERROR(INDEX([Work Order]:[Work Order], MATCH(VALUE([Pred#1]@row), [Row #]:[Row #], 0)), "") + IF(ISBLANK([Pred#2]@row), "", ", ") + IFERROR(INDEX([Work Order]:[Work Order], MATCH(VALUE([Pred#2]@row), [Row #]:[Row #], 0)), "")
As you can see in my sample above however, when you get 3+ predecessors this solution doesn't work. It is possible, but the formulas will start getting much more complicated involving the MID() function and lots of FIND() commas. It would get even trickier still if you have any lag durations in your predecessors (such as 2FS-2d... etc). So if you can keep it simple, the above solution should work for you, above and beyond that is going to take a lot more engineering time to work out well.
I hope this at least gets you in the right direction!
Jason Tarpinian
