Enhancement request -dynamic dropdowns in forms

L_123 ✭✭✭✭✭✭

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

Forumula help to extra characters from a cell
Morning I am hoping someone has an idea how I can achieve the following I have a barcode which is formatted like this when scanned into Smartsheet (01)00843997014755(11)240401(21)700040293 What I need for example is when the barcode is scanned into lets say cell A, then automatically cell B,C and D will extra data from…
Converting a date/time text format to a simple date format
Hey everyone - I am trying to convert a text field that reads 2024-09-25 15:35:27 to a simple date format, either 2024-09-25 or 9/25/24. I've tried using a helper column to just pull out the text date string - =LEFT([Registration date]@row, FIND(" ", [Registration date]@row) - 1) in the hopes that would be convertible to a…
what is wrong with my formula join collect?
=JOIN(COLLECT({Rollup Tracking: Preceptor Activity Month}, {Rollup Tracking: Preceptor Activity Preceptor Name}, [Preceptor Name]@row, {Rollup Tracking: Preceptor Activity QTR}, Qtr@row, {Rollup Tracking: Preceptor Activity Year}, Year@row), CHAR(10)) I cannot see why this doesn't work…i have similar formulas on other…