I have imported the file list from Google drive into Google sheet with Name, URL, Folder Path, Created Time, Modified Time, MIME Type and Size (Bytes) columns. I have added one more sheet called Sheet 2 into same Google sheet and added columns as Name, Email, Role and Folder Path. Objective of this sheet is to define which user role has access to which folder path. I have imported these two tables into Google App Sheet. I need to apply validation that if current logged in user has 'Leadership' or any other role mentioned for that matter under role column in Sheet2 then based on the folder path mentioned for the role it should display data from Sheet 1? I tried a lot of things but to no avail because there is no email column in the sheet populated from Google drive. Would really appreciate if you could help
Hello sir how would I add in showif i.e. Section 1 section 2 section 3 Same next Column appears in section 1 or section 2 while chosen . Not applicable in section 3
Sir humaare banaaye gaye app se milne wale responses ek particular sheet me jaate hain ...... Kya aisa possible hai ki app ke responses hum kisi doosri sheet me record kar sake ?
Sir kya aap formula bata sakte hain jisse directly responses doosri sheet me chale jaaye ...... Because jis sheet se app bana hai usme Mera main record hai jisko maine app me use Kiya hai and jo responses aa rahe hain wo usi sheet me neeche add ho rahe ...... Main chahta hoon ki records doosri sheet me aa jaaye
