Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

can i restrict data to dropdown menu only

Thabo Motaoane

Thabo Motaoane ✭

12/03/15 edited 12/09/19 in Archived 2015 Posts

can i restrict data to dropdown menu only

0 ·

Comments

Richard Rymill SBP ✭✭✭✭✭✭

12/04/15

In Smartsheet forms you can make the field compulsory to choose from the dropdown list. Or in the sheet Editors cannot change the Dropdown choices.
Dropdowns are a great way to drive quality into your data for analysis.
Hope that helps.
RichardR

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Is a blank date cell "not in the future"?
Working with automation, conditions, where date field is set to "is not in the future". How does that work with a blank field? Is a blank date field considered "is not in the future"? Or do I need to add an "or" date field "is blank" to this? (same goes for "is not in the past".
Percent Complete of Status Column
I am looking to have the Parent row show the sum of percent complete for children in the status column. Based on the photo attached, the formula I am using is not calculating the "Activity 1" cells being marked complete. I am using the formula: =COUNTIFS(CHILDREN([Status]@row), "Complete") / COUNT(CHILDREN([Status]@row))
SUMIF plus COUNTIF
Hi all, I asked another question in this thread. I now want to take a step further. I would like for the formula to sum the amounts in the SAR Loss column of my other sheet only if the Date Filed is between <Date 1> and <Date 2> AND the subcategory type matches @row. =SUMIFS({Date SAR Filed}, >=DATE(2024, 1, 1), {Date SAR…