-
Is there anyway to automate the process of moving an attached image to a cell?
The Smartsheet that I'm currently working on generates a document with images in it after a form is submitted. The images won't be placed onto the generated document, however, until someone manually moves the attachments to the individual cells. Is there any way to avoid doing this manually for every entry? It is similar…
-
Record Original Date
Hi, I'm trying to automatically record the first input in a cell (e.g. Project Start Date) in another cell (e.g. Original Project Start Date). Ideally, it'd be an automation that does this: If “Project Start Date” is changed and “Original Project Start Date” is blank, copy “Project Start Date” to “Original Project Start…
-
Joining two columns together for rows that match criteria
Hello, I have a sheet with many columns from which I want to pull [Data]2 and [Data]20, in this format: "Data2 (Data20), Data2 (Data20),..." from another sheet. So far we have =IF(ISBLANK([Source1]@row), "", JOIN(COLLECT({Data2}, {Data5}, CONTAINS([Source1]@row, @cell), {Major/Minor}, "Major"), ", ")) And get Data2, Data2,…
-
Networkdays/Workdays Excluding Holidays and Exceptions
Hello, I am having multiple issues with my calculations for NETWORKDAYS and WORKDAYS working in Smartsheets. I entered default holidays into the Non-Working Days (holiday, exceptions) box in the Account Administration field assuming that once I set up the holiday/exception dates Smartsheet would deduct these dates from the…
-
Metric Sheet Automation
Hello there, Thanks in advance for the help. I have a lot of data sheets that I want to summarize in one metric sheet. The data will be grouped based on the "assigned to" column. Right now, if I add a new line to one of these sheets, I have to go into the metric sheet to manually add in a row under that appropriate…
-
Limitations of Copying Rows
I have a sheet for each project my company works for. I am an admin on all of these sheets. We want to create an automation that copies the line to a separate sheet when a checkbox is checked. The idea being that the line in each sheet is copied to this separate sheet when a Project Manager directs someone to work on that…
-
Conditions for sending reminders about update requests
I have a use case where we have a roster of people (~300) and every six months we send them an update request to review and update their information as needed. I have an automation set up to send reminders to complete the update request but am having a hard time finding suitable conditions to filter out people who have…
-
Counting and Dividing Certain Cells
I want to divide the number of requests that were completed on time by the total amount of requests submitted that month. I'm referencing another sheet in my formula. The following is giving me "UNPARSEABLE" =IF({On Time?} = "Yes", {Submitted Date}, YEAR(@cell) = 2023, {Submitted Date}, MONTH(@cell) = 1) / ({Submitted…
-
Check Multiple Conditions Until a Trigger is Found
I'm trying to set up multiple conditions to copy a row over once if one of those conditions is met. I have set up multiple workflows, but it's copying the row over for each condition that is met. What I'm trying to achieve: If condition A is met, copy the row over. If condition A is not met, but condition B is, copy the…
-
Can you stop automations from running on completed projects?
We have been getting hammered by an automation that runs automatically for all jobs that have been completed in the past month or older. Is there a way to stop these automations via global updates? We have a separate sheet for every project and the automations are getting triggered from those. I don't want to go in and…
