- New Alert: Attachment view/download
I see that the activity log indicates an attachment was downloaded whenever it is viewed or actually downloaded. It would be useful to be able to set an automation alert that triggered whenever an attachment is viewed/downloaded. This would help address some security concerns with tracking who has downloaded what. Perhaps…
- 我怎么能自动添加数据吗dropdown list ?
Hi all, Sometimes i need to add new data to a dropdown list but it's hard for me to add because it's in a lot of different sheets. How do i automatically add data to all dropdown list column? (Python, Automation, Make, Zapier etc.)
- Dashboard Chart Widget Colors Automated?
We have a dashboard with lots of charts that show green, yellow, or red dependent on status from the source report. Ran into an instance today where the series was labeled green, but was showing the red harvey ball (meaning that our dashboard was reflecting 17 red projects instead of the correct 17 green). In a hurry, I…
- Generate PDF and email
Hi, I have a very simple sheet that I wish to turn into a PDF (all rows and columns) and email out each week when a value in a particular cell is changed. I can get an automation to send an email when the cell is changed, but I can't figure out how to generate a PDF which can then be attached to the email. Is it possible?…
- Change "End Date" based on status change?
Hello, all! Is it possible to change the "End Date" column based on when someone completes a task? Sometimes my team finishes a task on time. Sometimes it's a few days late. Sometimes (like today), a person finishes nearly a week early! Of course, if the end date is off, that messes with all successor tasks. We're doing a…
- Can you assign a random value based on a list?
I am trying to automate the task of assigning a person to an assignment. Users can submit a form, which generates a row on my sheet. The row then has to be manually assigned to someone to complete it. There are no values that can be used to really assign it to one given person- these are submission for setting up new…
- 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)…
- We are attempting to 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…
