-
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…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
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…
-
MM/DD/YYYY Date Format
Can we please add a MM/DD/YYYY date format to Smartsheet? I would like to feed this date into some DocuSign forms I need employees to complete, but they require a MM/DD/YYYY format in order for me to be able to utilize these dates.