Participant IV
Since ‎03-15-2019
‎01-16-2024

My Stats

  • 56 Posts
  • 6 Solutions
  • 0 Likes given
  • 7 Likes received

MM_Group's Bio

Badges MM_Group Earned

View all badges

Recent Activity

I asked ChatGPT for a solution, I need to split an enumlist and add each selection to a new row. It got quite close but the solution adds each selection to a new column instead of a row. The solution is below, would any of the 'Human' gurus take a lo...
Hi all.Is it possible to trigger a warning if two columns match a condition.My App selects parts to either Renew, Repair or Paint. The two columns in the row are:[CODE] & [Description]Example, If a user selects 'Renew' from [CODE] which is an Enum, a...
Bit of a tricky one this.I need an expression to return data for TODAY() and then after midnight as the day changes return data for the same day next week. Example:If today is Monday I want to see data for the current Monday (which is 11th December f...
In my Data Table, qryInProgressAppsheet there is a column called [JobID]. Within this table there is a ref rows virtual column which collects data from another table where [JobID] matches:REF_ROWS("Delays.csv","JobID")In qryInProgressAppsheet.JobID I...
Hi all.I need a format rule to highlight any date before TODAY() or within the next 7 days no further than that.The date column is [WEC] so I have tried a few variations:[WEC]>=TODAY()-7 which obviously highlights all dates greater than today - 7, I ...