How do I dynamically update a dropdown list?

I want to create a multi-select dropdown list with all future dates and this will be sent out in a form. Currently, smartsheet only offers a date selector with one max date.

I was wondering, is there a way to upload values into a dropdown through an API?

Otherwise, can I upload values into a dropdown from another sheet?

Please do not recommend me data shuttle again. I have already submitted a form to figure that out but no response so far.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!