Best Of

Re: Surveys Created from Forms for Public Access

Hi @Isis Taylor all of those security options are toggled off. I actually just figured out how to disable that message to download the app, I think you and I were typing at the same time, LOL!

You have to turn off the Smartsheet footer. I toggled with the footer and saw that this made the difference. 😀

Thanks for your willingness to help!

Netra

1 ·

Re: Auto Populate cell with a symbol in front of the value

Hello @James Preston,

There is a way to achieve this. Go to Edit your form and click on the column where you want a numerical value. On the right side under Field Settings, scroll down to Validation and select Number only. I would also add "Help Text" stating, "apply only the numerical value on the form e.g. 80". Then save the changes.

Next, go to your sheet, click on the column with the numerical value, then click the three dots (near Share in the upper right corner), and select $, then the applicable currency.

Hope this helps!

mcullen

1 ·

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

One skill I'd like to improve is quilting. I’ve always admired the art and creativity that goes into it, but I think I could really benefit from learning more advanced techniques and improving my stitching precision. It’s a relaxing and rewarding craft, and I’d love to be able to create more intricate designs!

mcullen

4 ·

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

A skill that could use improvement for me is cooking- I am slowly learning more but there are still lots of things to learn to be more confident in the kitchen!

Janae G.

2 ·

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

Congratulations @Julia L Rumburg with all your success!

Ruby Gonzalez

1 ·

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.