Silver 1
Since ‎08-16-2022
Saturday

My Stats

  • 57 Posts
  • 2 Solutions
  • 25 Likes given
  • 20 Likes received

RichardChen's Bio

Badges KathB27 Earned

View all badges

Recent Activity

I have 3 conditions to meet:1. If either the "Month" or "Type" columns are blank, it will display all the details. 2. If the "Month" column is not blank, it will display the details from "Transportation" table only if the selected "Month" matches the...
Hi All,I copied the Tenant Logistics template in Appsheet and want to incorporate it for our Lockers issuance at work. The formula used in google sheets for column Employee ID in the Lockers Sheet was:=IF(AND(NOT(ISERROR(VLOOKUP(A3, SORT('Move-in'!C:...
Hi All,Need your help with the Action button i am trying to create.I have 3 tables:1.) Employee Details Table2.) Lockers Table3.) Move-in Date TableI want to create an Action button on employee table to auto create a row in Move-In Date Table and at ...
Hi All,I have set up an email bot for this inventory app im working with. That when the current stock hits the Safety Stock level and the status turns to Reorder, it will send email notification. However, the email notification keeps sending everytim...
hello again,i wanted to add the "Not Ready" in the formula but it's not working, am i missing something? Please help. IF(AND([Warehouse Status]="READY FOR DELIVERY",[Fabrication Status]="READY FOR DELIVERY"),"READY FOR DELIVERY", "NOT READY"IF(LIST[R...