About Bean

Bean · 01-24-2022

Hi Community, I’m having trouble using the ChangeTimestamp feature in conjunction with CSV uploads. When uploading or updating a row with import data (csv upload). The datetime is formatted in UTC but as you can see in the USERTZOFFSET() column, reco...

Bean · 01-24-2022

Happy to provide more info too if its helpful

Bean · 01-24-2022

@Marc_Dillon way works well (probably better) and is concise if set up properly. This way will work with your current system - (this goes in the Valid If column of the Size field) IFS( [Clothing Item] = "Tee Shirts", Clothing Sizes[Tee Shirts], [Clot...

Bean · 12-23-2021

@JPAlpano & @Phil Update - I think I found a solution using the INTERSECT function. Legend: [Units] is my enumlist field I’m applying these conditions to, and [Unit] is my enum column. Main Idea: split your input [Units] to get a list and compare how...

Bean · 12-23-2021

@JPAlpano & @Phil Our team is very much following this thread and interested in any developments. Please let us know if there is a solution or someone figures a workaround. Is there a way to bypass the valid if on upload for that field but keep the v...

My Stats

davidc2's Bio

Badges Bean Earned

Recent Activity

Trouble creating Last Modified column using ChangeTimestamp (CSV Upload / UTC Conversion)

Re: Trouble creating Last Modified column using ChangeTimestamp (CSV Upload / UTC Conversion)

Re: Dependant Dropdown based on another dropdown referencing certain columns

Re: CSV Upload EnumList ValidIf Error

Re: CSV Upload EnumList ValidIf Error