tag:blogger.com,1999:blog-6799428426680372912.post766706598263761657..comments2023-11-15T17:26:49.562+05:30Comments on iGoogleDrive: Google Spreadsheet Multi Sub Drop Down ListKishhttp://www.blogger.com/profile/13751098853627072874noreply@blogger.comBlogger48125tag:blogger.com,1999:blog-6799428426680372912.post-59950333088739074082018-07-29T07:00:03.398+05:302018-07-29T07:00:03.398+05:30Im still trying to find a way to reference a diffe...Im still trying to find a way to reference a different sheet. Let me know if you find a way<br />Anonymoushttps://www.blogger.com/profile/00780248154139273933noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-56780691040960506602018-07-29T06:57:06.375+05:302018-07-29T06:57:06.375+05:30Simply genius! I've been searching for a solut...Simply genius! I've been searching for a solution, and this was absolutely fantastic simple solution! Congrats!Ederhttps://www.blogger.com/profile/00515541899074269629noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-67599069186845715882018-06-25T16:04:30.295+05:302018-06-25T16:04:30.295+05:30Hi Experts.
I have a question
How do I send out ...Hi Experts.<br /><br />I have a question<br /><br />How do I send out automated conditional emails once everyday based on value of a certain cell (to certain recipients mentioned in a particular column of the sheet).<br /><br />The subject line and content would have references from certain cells in the same sheet. This would really help me improve my functioningKavish Munimhttps://www.blogger.com/profile/17422763488295919765noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-72066688020059915472018-06-11T05:22:04.477+05:302018-06-11T05:22:04.477+05:30@mreighties or @Lon Binder, How can I reference a ...@mreighties or @Lon Binder, How can I reference a different Sheet?Dave Putzhttps://www.blogger.com/profile/09976871124146009762noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-1804883398895895572018-06-11T00:01:49.724+05:302018-06-11T00:01:49.724+05:30There is no comma after K13 which is needed to cre...There is no comma after K13 which is needed to create the final argument in the last IF.mreightieshttps://www.blogger.com/profile/18225707316156386271noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-7550976001813061452018-05-09T17:30:38.664+05:302018-05-09T17:30:38.664+05:30Lon, how can i change the script to indicate a dif...Lon, how can i change the script to indicate a different sheet. The script works great however when it copies it only will reference current sheet.Dave Putzhttps://www.blogger.com/profile/09976871124146009762noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-35044846963667820012018-05-09T17:30:02.378+05:302018-05-09T17:30:02.378+05:30This comment has been removed by the author.Dave Putzhttps://www.blogger.com/profile/09976871124146009762noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-66609870400034802952018-05-09T17:29:06.770+05:302018-05-09T17:29:06.770+05:30This comment has been removed by the author.Dave Putzhttps://www.blogger.com/profile/09976871124146009762noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-3813704444478355252018-02-15T16:04:02.066+05:302018-02-15T16:04:02.066+05:30@Lon Binder could u please share the script for va...@Lon Binder could u please share the script for validation+ menu Anonymoushttps://www.blogger.com/profile/08699570846828421979noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-77758414279759691292017-11-05T13:14:52.953+05:302017-11-05T13:14:52.953+05:30@Lon Binder - Hi Lon, I have just looked at your e...@Lon Binder - Hi Lon, I have just looked at your example Spreadsheet in the link provided. Unfortunately it seems to have been changed. Could you please restore the sheet back to its original working version again?Doughttps://www.blogger.com/profile/16612016983547930493noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-4648509887750360802017-07-26T06:43:08.001+05:302017-07-26T06:43:08.001+05:30@Lon this is def what I need I just don't unde...@Lon this is def what I need I just don't understand it (sooo not a techie person!!)<br />anamaefordhttps://www.blogger.com/profile/06898766271645365997noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-3932801477647392652017-06-01T21:35:03.800+05:302017-06-01T21:35:03.800+05:30hello,
i could really use some help. I am using d...hello, <br />i could really use some help. I am using data but ranges a:k rather than just a:c , im getting an error message. <br /><br />this is the formula im entering: <br />=arrayformula(if(GUESS!E3=A1;A3:A15;if(GUESS!E3=B1;B3:B9;if(GUESS!E3=C1;C3:C10;if(GUESS!E3=D1;D3:D9;if(GUESS!E3=E1;E3:E6;if(GUESS!E3=F1;F3:F6;if(GUESS!E3=G1;G3:G8;if(GUESS!E3=H1;H2:H10;if(GUESS!E3=I1;I3:I8;if(GUESS!E3=J1;jrodhttps://www.blogger.com/profile/10040390849059437873noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-59334718182395362712017-05-17T06:56:31.690+05:302017-05-17T06:56:31.690+05:30This comment has been removed by the author.rhainhttps://www.blogger.com/profile/04642785232799592442noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-14010104602415892192016-12-23T19:07:57.157+05:302016-12-23T19:07:57.157+05:30I just found this now but can't seem to find t...I just found this now but can't seem to find the "Validation+" script you are referring to.hp9200https://www.blogger.com/profile/04871598953937829910noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-65308150797179387042016-12-15T02:45:24.166+05:302016-12-15T02:45:24.166+05:30Sir,
Where is the Validation+ script and how to u...Sir,<br /><br />Where is the Validation+ script and how to use it?<br />I am unable to find, please let us know.Satbirhttps://www.blogger.com/profile/05309681086163485386noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-53253752356107552172016-08-08T04:13:55.715+05:302016-08-08T04:13:55.715+05:30Hi.. I dind't find the script "Validation...Hi.. I dind't find the script "Validation+". Is that still working?Anonymoushttps://www.blogger.com/profile/12970477296281189425noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-77523057664807637692016-01-12T03:44:06.674+05:302016-01-12T03:44:06.674+05:30Thanks!Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-38434210951124961772016-01-12T01:46:30.813+05:302016-01-12T01:46:30.813+05:30@Unknown - I've restored the sheet back to the...@Unknown - I've restored the sheet back to the original, working version.Anonymoushttps://www.blogger.com/profile/09105526041461364124noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-33234334402988940942016-01-12T01:07:52.259+05:302016-01-12T01:07:52.259+05:30Unfortunately, too many people were in the example...Unfortunately, too many people were in the example spreadsheet, made changes, and now it is unreadable. If you have a copy of the original, please post it up. I would love to learn how to do this with multiple columns. Thanks!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-27635899759413975342015-10-16T23:23:49.202+05:302015-10-16T23:23:49.202+05:30But how do you cause the 2nd dropdown to go blank ...But how do you cause the 2nd dropdown to go blank when the first drop down is changed to prevent a validation error?Anonymoushttps://www.blogger.com/profile/17873702499483917494noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-33378884580417379672015-10-08T01:29:56.969+05:302015-10-08T01:29:56.969+05:30Never Mind. I figured it out. The format had to ch...Never Mind. I figured it out. The format had to changed to 'plain text'QQhttps://www.blogger.com/profile/08399089931136812480noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-90943461322938332032015-10-08T01:25:00.021+05:302015-10-08T01:25:00.021+05:30In the above example I am getting values fine upt...In the above example I am getting values fine upto the step where E1 is populated based on B1. But when I try to add validation for B2, it picks up the formula From E1 instead actual values. What am I doing wrong?QQhttps://www.blogger.com/profile/08399089931136812480noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-65629040477492489282015-10-06T01:44:13.141+05:302015-10-06T01:44:13.141+05:30How can I restrict the number of responses per dro...How can I restrict the number of responses per drop down item. For example, if I have in cell drop downs of appetizer, entree and dessert, and I want only 10 people to sign up for dessert, how would I do that?C Slaytonhttps://www.blogger.com/profile/04123842602258098842noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-44626745454840832452015-10-06T01:43:49.991+05:302015-10-06T01:43:49.991+05:30How can I restrict the number of responses per dro...How can I restrict the number of responses per drop down item. For example, if I have in cell drop downs of appetizer, entree and dessert, and I want only 10 people to sign up for dessert, how would I do that?<br />C Slaytonhttps://www.blogger.com/profile/04123842602258098842noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-83935915447610844962015-06-05T17:54:45.115+05:302015-06-05T17:54:45.115+05:30What does SEAV stand for?What does SEAV stand for?Anonymoushttps://www.blogger.com/profile/14965035945337851804noreply@blogger.com