-
Sheet Owner on Automation Emails
When a notification is sent, the automation email is sent like it is coming from the Sheet Owner rather than the user that actually updated the row and triggered the notification. This is confusing because often times our customers don't know who the sheet owner is or they don't interact with that person. Can this be…
-
Nested COUNTIFs within Date Ranges
Hi Smartsheet Experts, I need some help creating a formula. The Source sheet contains the data and I have formulas on another sheet; therefore, the formula will contain cross-sheet references. Source Sheet looks something like this: I want to count the number of Items that have an ORIGINAL or NEW date in January 2021 but…
-
automation with clock timer
Hello , Date column is not enough for automation updates/approvals and reminders , we need to send it conditioned on time formula ( clock ) . For example like to insert task time and and to create automated reminder / update or approval request that with condition based on time , like if the time is 1,2, 3 hours is less…
-
Workflow automation to alert people upon cell change from 'unchecked' to 'checked'
Hi, An automation workflow is created. Specific people are assigned to be alerted upon cell change for specific row from 'unchecked' to 'checked'. Workflow to run when triggered. After trying multiple times, the workflow seems not to be active and working. See image below. Please advice, thank you.
-
Is there a way to convert the content of cells obtained through formulas to static content?
At the end of every fiscal year, I'd like to be able to create a sort of "Snapshot in time" from some of my sheets. Also some of these sheets are feeding dashboards and I'd like to "archive" the dashboards as well. The ideal solution would be if there is a way to almost "shut off" the formulas in a sheet but keep the…
-
Can data uploader load new rows to top of smartsheet instead of the bottom?
I know there is a setting that allows when users submit new lines from a form, to insert them at the top of the smartsheet, but does the data uploader have this same ability? I have a monthly report that I upload to a smartsheet and it always puts the new rows at the bottom. I then have a dynamic filter that my users use…
-
Copying multiple rows between sheets - Including formulas, formatting
Hello I'm having a hard time figuring this out. I have two sheets. On the target sheet I have a set of formulas and hyperlinks. On the other sheet I need to have basically everything (Except a few rows) under the existing parts of target sheet. I have tried everything. Ctrl + C/V -> Got me the text over, but all in white,…
-
Query on Created Date Returns incorrect results
Hello and Happy New Year! I have a sheet with a Created date column defined as below. I've created a filter to return all rows "greater than" a specific date in this column however the filter returns rows greater than or equal to the date in the filter. Is this because there is a time stamp and anything greater than 00:00…
-
Moving Parent and Child rows to other Sheets
Hi, Looking for some help moving rows to another sheet. We use one specific sheet to track ALL deliveries that come into our warehouse. A clerk in the warehouse makes a Form Entry for every group of items on the same packing slip, and attaches a photo of the packing slip for reference. Remotely, another clerk will read the…
-
Auto fill date
Hi, Is it possible to set a date cell to auto-fill based on a date from another cell? I'm setting up a task list which tracks the ordering of materials required to sites. I have a column 'date required on site'. I am adding another column 'order to be placed by'. If we know that the supplier requires say 3 weeks notice to…
