Best Of
Re: Autonumbering of Children Items
I've done this before with a lot of helper columns. If somebody has discovered a more efficient method, please do share! Create the columns in the order below:
- "AutoNum" = create an # Auto Numbered column
- "UniqueID" =IFERROR(Primary@row + AutoNum@row, "")
- "ParentID" =IF(COUNT(ANCESTORS()) = 0, "Top", "R" + PARENT(AutoNum@row))
- "Child#" =MATCH(UniqueID@row, COLLECT(UniqueID:UniqueID, ParentID:ParentID, ParentID@row), 0)
The "Child#" field will then auto-calculate what number child it is, no matter how many levels of parent/children you could put on the sheet.
Jason Tarpinian
Re: Meet Julia L Rumburg, our February Member Spotlight! ๐
Way to go @Julia L Rumburg! ๐
Yvonne Smythe
Re: Writing a reference formula with multiple IF/AND situations
Happy to help! ๐
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet starts off as glorified excel for newbies, but once you start using it and learn about all the tools and resources, it goes from being a fancy spreadsheet to a one stop shop project command center.
chair
Re: Happy 10th Anniversary Community + Giveaway!
In one sentence - How would you explain Smartsheet to a newbie?
Smartsheet allows multiple users to work within a sheet at same time without having to raise your hand and wait your turn.
KevinThiel
Re: Happy 10th Anniversary Community + Giveaway!
Smartsheet is the friend you never knew you neededโฆliterally has a tool for every job!
Lynne D
Re: March Question of the Month - Join the conversation and receive a badge
Great question! The one skill Iโd like to improve is the ability to be more understanding rather than always trying to be understood.
Yvonne Smythe
Re: March Question of the Month - Join the conversation and receive a badge
Time-based reasoning is the skill I'm eager to develop
Humashankar
Re: March Question of the Month - Join the conversation and receive a badge
I'd like to improve my skills as a solution architect to better align people and processes.
Isis Taylor
Spread the word! Smartsheet User Group in Dallas, TX
๐ข Attention Smartsheet Community! Join us for an upcoming User Group session in Dallas, TX on Tuesday, March 11th! A few spots are still available, so donโt miss this opportunity to register and bring your colleagues along.
Connect with fellow Smartsheet users, explore new ways to maximize the platform, and walk away with some exclusive Smartsheet swag!
๐
Date & Time: Tuesday, March 11th, 2:00โ5:00 PM (local time)
๐ Location: The Westin Dallas Fort Worth Airport, 4545 W John Carpenter FWY, Irving X 75063
Secure your spot todayโwe can't wait to see you there!
If you have any questions, reach out to us at usergroups@smartsheet.com.
Kelsey Hayden