- automated sending of attachment
Hello Community, I have created PDF's from data gathered in a form. I want to send the PDFs back to the contact (a column in the sheet) but I don't want to send links to the sheet. Is there any way to do this in automation. I realize it can be done manually. Thank you, PeterL
- Avoiding (email) notifications if assigned to = modified by
Hi all, I have set up a market research project plan with around 60 tasks. Each task is assigned to specific person(s) (could be multiple). I have a workflow where they 'assigned to' contact receives a (email) notification if the row on which he/she is 'assigned to' is changed. However, I only want them to receive (email)…
- 我们正试图make a column from 1 sheet auto fill onto a second sheet and add new rows
We are making a database. We made a sheet for this (AllJobs3) and are attempting to have this sheet pull the Primary Column from a master sheet (All41). We only want the primary column as the database doesn't require all fields. We have been messing with INDEX(COLLECT), INDEX(MATCH), & VLOOKUP but we cannot seem to get it…
- Smartsheet Automated Emails changing custom subject line
Good Morning, I've have several workflows setup to send out emails that are triggered by dates. I'm using the Alert someone and I have setup specific subject lines in each out these, based on the time frame of a requested completed date. This morning, I received a "Reminder: Smartsheet Name" email that was sent to all who…
- Copying rows, but without automatically adding every single column into the 2nd sheet
I didn't see a discussion about this with a quick search, so here goes: When I copy a row from one sheet to another, the 2nd sheet automatically gets updated to include every single column in the original sheet. This is a real hassle when I have 220 columns in the original sheet, but really only want 40 or so of them in…
- Nested IF Function using Harvey Balls
Hi SS Community, I have the following nested IF column formula . The formula works properly through the "Red" part, but once I attempt to type DECLINED in the "Revised Final Date" column, the formula returns #invalidoperation. What can I change in my formula to show a Gray Harvey ball when I type DECLINED in the "Revised…
- How to Write IF Statement for a Symbol Column
I have a Symbol column that I'd like to auto-change to Green, Yellow, or Red depending on the date values in my Start, Finish, and Project Status columns. For instance: If Start is in the past and Finish is in the future and Project Status is not "Complete" or "In Progress", Symbol changes to Yellow. I really wish…
- VLOOKUP or INDEX MATCH Referencing Another Sheet
I would like to pull "Type" from a different sheet by matching the Project #. I've used both INDEX MATCH and VLOOKUP formulas which has worked well! Here are the formulas: =INDEX({Program Intake Form Range 1}, MATCH([Project #]#, {Program Intake Form Range 2}, 0)) =VLOOKUP([Project #]#, {Program Intake Form Range 2}, 5,…
- Is there a way to create alerts for non-specific changes?
I'm trying to create an automation that will send an alert when a certain value changes by more than 7. I don't just want an alert for any change, it has to be if the value changes by more than 7. Because of the nature of this specific value, it isn't really possible to have a helper column, at least not that I can tell.…
- Uncheck Box
I have a formula that says IF(Date@row
