Thank you for doing this video! Can we remove an item? Lets say your product was discontinued, how would you update the drop down to not show it any longer?
Is this workflow replacing the existing dropdown list with the current or adding new items? I'm asking because I would love to connect this type of flow from Sheet A to the dropdowns in Sheet B however sheet A archives items that may still be valid for Sheet B. So if it is simply adding additional dropdown selections great but if it's completely scrubbing I'll need to dive deeper for a perfect solutions. Thanks for all your content!
Hi Casey - apologies for delayed response! In this case it’s adding new items. With data shuttle you can set it to add to or replace existing content so sounds like it will do exactly what you’re after
Thank you for doing this video. I finally convinced my boss to buy Smartsheet and overall I love the product, but month after month we run into hiccups that shouldn’t be there. I shouldn’t need to buy a premium add-on just to update a dropdown automatically. The fact that you can run Data Shuttle on a set date/time schedule, but you don’t have that flexibility with Data Mesh is trash. It seems as if there is not top down, umbrella guidance for the product teams.
Hi @Roccofan! We're just checking in on you. How is your Smartsheet journey going? Please reach out to us if you need any help - we're always here to help you achieve #PeakHuman status
Best thing to do is use set this as a column formula assuming you have dates listed (if not, then set one date then create a formula = [starting date] +1): =IFERROR(IF(WEEKDAY(Date@row) = 1, "Sunday", IF(WEEKDAY(Date@row) = 2, "Monday", IF(WEEKDAY(Date@row) = 3, "Tuesday", IF(WEEKDAY(Date@row) = 4, "Wednesday", IF(WEEKDAY(Date@row) = 5, "Thursday", IF(WEEKDAY(Date@row) = 6, "Friday", IF(WEEKDAY(Date@row) = 7, "Saturday", ""))))))), "")
Excellent channel about the advanced usage of Smartsheet! Huge thank you!
very kind of you, thank you!
Thank you! This was super helpful
Delighted to have been of help!
Thank you for doing this video! Can we remove an item? Lets say your product was discontinued, how would you update the drop down to not show it any longer?
As long as the source that updates the dropdown is up to date, then it will show use list. So remove it from the source.
Is this workflow replacing the existing dropdown list with the current or adding new items? I'm asking because I would love to connect this type of flow from Sheet A to the dropdowns in Sheet B however sheet A archives items that may still be valid for Sheet B. So if it is simply adding additional dropdown selections great but if it's completely scrubbing I'll need to dive deeper for a perfect solutions. Thanks for all your content!
Hi Casey - apologies for delayed response! In this case it’s adding new items. With data shuttle you can set it to add to or replace existing content so sounds like it will do exactly what you’re after
Thank you for doing this video. I finally convinced my boss to buy Smartsheet and overall I love the product, but month after month we run into hiccups that shouldn’t be there. I shouldn’t need to buy a premium add-on just to update a dropdown automatically. The fact that you can run Data Shuttle on a set date/time schedule, but you don’t have that flexibility with Data Mesh is trash. It seems as if there is not top down, umbrella guidance for the product teams.
Hi @Roccofan! We're just checking in on you. How is your Smartsheet journey going? Please reach out to us if you need any help - we're always here to help you achieve #PeakHuman status
Is there any way to drag-fill the week names?
Best thing to do is use set this as a column formula assuming you have dates listed (if not, then set one date then create a formula = [starting date] +1): =IFERROR(IF(WEEKDAY(Date@row) = 1, "Sunday", IF(WEEKDAY(Date@row) = 2, "Monday", IF(WEEKDAY(Date@row) = 3, "Tuesday", IF(WEEKDAY(Date@row) = 4, "Wednesday", IF(WEEKDAY(Date@row) = 5, "Thursday", IF(WEEKDAY(Date@row) = 6, "Friday", IF(WEEKDAY(Date@row) = 7, "Saturday", ""))))))), "")
See this video ua-cam.com/video/rKntYwGYwqU/v-deo.html
Hi, how can i get this add on?
You need to contact Smartsheet directly