- Copy Rows Automation - Only certain columns?
When a copy row automation is triggered, is there a way to only copy certain columns/cells in that row? If not, is there a way to then take the output sheet data and cross reference to matching rows in a third sheet, and can I build further automations off of the destination sheet?
- Attachment Security / Scanning
Hello, Does anyone know if Smartsheet has any virus scanning or other security/anti-malware features applied to file uploads and attachments? I just want to see how much effort and trust we should place in file attachments received via form uploads from our clients. Apologies if this is addressed in a help article -…
- Summarize duration in a project sheet by week/date range?
Is there a way to summarize the DURATION data in a resource-enabled project sheet by week or a given date range? i.e., I want to see total hours for the last week by person. I already have a helper column inserted which converts DURATION to hours. Thanks!
- Problems report filter and logic formula not recognizing today and yesterday in date column
I'm trying to get my report to filter based on rows where the date column "Last Response Received" is not today or yesterday: Last Response Received is a date column that has another formula: MAX(COLLECT(External sheet reference)...) which returns the most recent date (from a user's input of form data into a separate…
- Automation - Is it possible to re-send an approval workflow?
Hello, I have an approval request workflow setup that sends data input from a Smartsheet form. Unfortunately, some of our approvers are losing the approval request email in their inbox or not responding to the approval requests in a timely manner. Is there a way to re-send the approval request for outstanding approvals…
- Return the largest date value from an external sheet array
Hello, I'm trying to return the max date from an external referenced sheet's system Created date column ("Response Date") based on matching the multiple values in another column in the external sheet an email address/name from the current sheet. I've tried using =MAX(COLLECT(Response Date, Email Address Column, Email…
- Copy Rows Automation Not Firing & Clearing Cell Data
Hello, We are trying to build out a simple employee "check in" sheet that will collect data from all our employees on if they will be in the office, and if so, indicating by a checkbox column. My initial approach was to have a daily, repeating update request automation go out to everyone at 8am every weekday morning (each…
- Summarize project sheet hours by person
Is there an easy way to summarize the total hours for all tasks on a project sheet by person? I know I could use SUMIF/SUMIFS, but the problem is that I don't know how to provide it with the input criteria for the Assigned To column in a simple manner since that can be anyone of our 30+ team members. I'm sure there must be…
- Sheet Summary Report - Edit Sheet Data possible?
Can sheet data be edited directly from a Sheet Summary report similar to a "regular" report? The Sheet Summary fields that are in the report are all formula driven (mostly just links back to specific cells within the sheet).
- Does automation ignore changes to rows caused by automation?
你好,这可能是一个愚蠢的问题,but if I have an automation trigger set for "When rows are added or changed", is Smartsheet "smart" enough to recongize not to fire an automation that was triggered by an approval automation? For example, I want to request an approval whenever a new row in my sheet is added (which is…
