Best Of

Re: March Question of the Month - Join the conversation and receive a badge

Some skills that I would like to improve on is my time management and organization. I participate in many events outside of my day job, so being able to balance all of this will help me with maximizing my productivity.

Thumphrey

2 ·

Re: Let's celebrate our Global Community

One thing about me is I love teaching line dancing. I have for the past 3 years been an instructor at a community event here in Delhi, New York for our Senior Citizens Day!

AngB789

1 ·

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

1 ·

Re: Meet Julia L Rumburg, our February Member Spotlight! 🎉

Way to go @Julia L Rumburg! 🎉

Yvonne Smythe

2 ·

Re: Writing a reference formula with multiple IF/AND situations

Happy to help! 😁

jmyzk_cloudsmart_jp

1 ·

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.