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 need help extracting a date from a string of text. I tested each component (year, month, day) separate and get the right result. However, when I put the extraction formulas together in a DATE formula (in a Date column type) I get INVALID DATA TYPE. Sample text string: 2025-10-20T23:26:16+03:00 Formulas that work…
I am trying to pull over a date from one sheet, based on the lookup value and return a date from another smartsheet. I am getting unparseable at the moment from this formula. Also the column ([PIN]@row) reference it not lighting blue. =VLOOKUP([PIN]@row ],{FD Filers' list - PIN#ref},6,false) Any suggestions?
I want to take a smart sheet and have a reminder date column. East task that I have I want it to calculate off the duration to give me a reminder to do the task. Ex: Send pricing → Nov 1 of the year before the class Send brochure → 6 months before class date Check website for class → 90 days before class date Check in for…
