About Giane_Mosquera

Giane_Mosquera · 02-27-2023

Hello I have a table named JANUARY, which has a column "Cost Center" and other columns for values to show.I also have a USER table, having "Email" and their assigned "Cost Center".Now I have created a slice where a USER only sees rows having the same...

Giane_Mosquera · 02-08-2022

Hello, I have a reservation appsheet project and I have applied the following expression on the column's valid if that validates overlapping reservations:Notice on the last line I've put [Status] = "Approve", this adds to the validity that it can rec...

Giane_Mosquera · 02-02-2022

I have the columns Hours Used and Minutes Consumed on my dataset and they are on Number Type with their own formula for their respective calculations:The output is correct when they're on my source table (google sheet): But when they are presented on...

Giane_Mosquera · 06-12-2023

Hello @krupan-google . Is the upcoming release due soon? 

Giane_Mosquera · 06-12-2023

Hello, @MultiTech . I visited the link and tried to add a "Run a data action" and add new rows using a scheduled automation. My ForEachRowInTable is disabled yet i can't add a Run Data Action on the task. Are there any workaround for this?

Giane_Mosquera · 02-28-2023

Wow. Yes I had to change the type of [Cost Center (old)] into ENUMLIST to make it work. Thank you so much!!

Giane_Mosquera · 02-27-2023

I added List() since In() looks for a list in its function. I got this working for only ONE assigned cost center ( example: 2111):It's working for a single value. But when I assign two values (2111 , 2231), no items are shown on my slice  I used the...

Giane_Mosquera · 02-27-2023

Hello @TeeSee1 , how do I utilize the IN() along with the assigned email and cost center on my USER table? Also, the slice is from the January Table.

My Stats

Giane_Mosquera's Bio

Badges Giane_Mosquera Earned

Recent Activity

How do I make a slice filter with two values on a single cell to compare to another table?

Reservation overlap with Approval

Attachment Template (from automation) Number format different from source sheet.

Re: Bot to add rows to tables on a schedule

Re: Add New Row automatically to the Table

Re: How do I make a slice filter with two values on a single cell to compare to another table?

Re: How do I make a slice filter with two values on a single cell to compare to another table?

Re: How do I make a slice filter with two values on a single cell to compare to another table?