Hi all, I've been working with my sheet on sending automated emails to contacts within the sheet and can add specific parameters for what is in a cell. However, I can't figure out how I can display th…
Hi All, I have a sheet where customers send a submission and get automated emails with field data that they submitted. I want to provide details of the assignee of their submission but want to provide…
Hi, I'm trying to create a formula that will change a cell in a particular column if the value in another column is Yes or No. For example, I have a column of statuses and another column confirming if…
I want to look up a value from a dropdown in one column and enter text into another column based on the value found in the first column - is this possible? I can't seem to work it out! For example, if…