Enhancement request -dynamic dropdowns in forms

Options

L_123 Community Champion

03/25/22 edited 03/25/22 in Formulas and Functions

Haven't seen this topic brought up in a minute, so thought I would bring it back up.

Dynamic dropdowns in forms would be huge for us.

Tags:

1 ·

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Unparsable Error for formula
I need to sum data in one column based on the month and year. =SUMIFS({011-AP Archive Computed Count}, {011-AP Archive Month}, 12, {011-AP Archive Year},2025)) I did the same formula for COUNTIFS, and it worked beautifully. =COUNTIFS({011-AP Archive Month}, 12, {011-AP Archive Year}, (2025)) Any help will be appreciated.
Index Collect Has with a multi select reference column
I am working on a formula that will reference a column in Sheet A that may have multiple choices selected, and compare it to a column in Sheet B that will match one of the selections in Sheet A and return the word 'Completed' I've tried these 2 formulas and both return #INCORRECT ARGUMENT =INDEX(COLLECT({Equipment…
Counting Rows in a date range
I've been trying to just create a formal in my sheet summary to show a count of issues i have on a sheet (number of rows) between a date range, so how many issues were raised in 2024, I've got a Row ID column with auto numbering which i'm trying to draw on but i keep getting error messages? I feel like it's a simple count…