Sign in to join the conversation:
hi,
Is there a way that if I choose a name from a drop down box in one column it will show the appropriate email address in another column?
regards,
Mark
Hi Mark,
Yes, it is but what would be the best setup depends on your specific needs.
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)
Hope that helps!
Have a fantastic weekend!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
I am trying to find the next upcoming Date and its associated Task based off what activity is being performed and where it's taking place. The formula I have to find the next upcoming date works perfectly: =MIN(COLLECT({Date}, {Date}, >=TODAY(), {Activity}, ="Activity ", {Area}, ="Area")) My problem is trying to get the…
Hi I need to add a formula on the end of this formula please. I need to add if 2026 investment list is checked too. This is the formula =COUNTIFS({Exec Sponsor}, FIND(Metric@row , @cell ) > 0, {Intake Status}, FIND("Project Approved", @cell ) > 0)
Hi I am tryingbuild a new Stock Control system using barcode reader on my mobile feeding into the sheets. The issue I have is adding the items up on one sheet and adding to items to another sheet to work out stock levels. I am tried using the barcode or ref no as the Lookup.
