-
Smartsheet Enhancement Request: Snapshot/Print Workflows
I have made several workflows that were fairly large for different applications in smartsheet. I would like to have a simple function to print/pdf the workflows so as to see all of one at once. This would help me with design, troubleshooting, and communicating the process to those involved in it. I have submitted an…
-
#Invalid operation error for summing values
Hello Team! I have a weird case, but let's go straight to the point. I have a simple formula: =SUMIF([F Tracking ID Number]:[F Tracking ID Number], [F Tracking ID Number]@row, [X ASIN Value (CI)]:[X ASIN Value (CI)]) which basically sums values from column X for duplicate values in column F. The formula works fine for…
-
Merge all attachments of a sheet into one PDF?
Is there any way to automate merging all of the attachments of a sheet into one PDF? I was thinking of using zapier or Microsoft Flow but I haven't been able to figure out a good and simple way to. Ultimately I want the end users to be able to do so with only one trigger (after the sheet has all of the attachments.) Thanks…
-
Why are selected dates displaying 1 day prior?
If I enter Jan 19, 2023 in the due date field, it appears as Jan 18, 2023. No changes have been made to the settings.
-
Understanding Smartsheet User Profile Discrepancies: Name vs. Email Address in Workspaces and Sheets
Hi all! I've got an issue with Name and Email Address of a Smartsheet User not "linking" (for want of a better word). Please bear with me as I try to explain the problem! :) A Smartsheet user needs to be shared to a workspace. When I searched their name in order to share it with them, it shows me their name as they've…
-
copying data from row above to rows below via column formula
With form 1 in this example we enter account manager, client hit submit, the another form opens to fill in the services performed, so our users don't have to fill in redundant information for each service. Is there anyway to use column formulas to fill in the Updated Account Manager so when we use reports we can filter…
-
How to add column that shows start/finish time in minutes?
I see you can list a task in minute increments, e.g. 15min. We are creating a cutover plan and need to list a start & finish TIME: e.g. 9:00, 10:00, etc. Does Smartsheet have this as an "intelligent" column or just a text/number one only? Would be extremely helpful, so that folks can time the work and also, if you add…
-
Max Row Within a Group
Hello, I have sheet that gets a row added every time someone add a response. The example shown is a simplified version. Each response is associated with a Group of combined columns (1 company + 1 ticket) - See column named "Join". Users can add a new response for each Group over and over. Each time they add a row, the…
-
Generate Document Text Customization
When generating documents, there is a preset text and text size. There are no options to customize. Often, the preset text does not match the text format on the document.
-
'Helper' Column Management via New Column Type (or Side Panel?)
Many of us, if not most, use one or more helper columns to achieve the Sheet functions that we need. Good practice is to hide the helper columns (when possible) so that the sheet user isn't bombarded with noise. Unfortunately, hidden columns still appear while in Card View. My solution for this is to move all of the helper…
