-
Populating cells in a column with data from cells from a different column on the same row
Hi, I'm currently trying to build a column where if the cells are blank, they are populated with the data in a cell on the same row but obviously in a different column. This sheet is populated by form entries and I'm trying to fill this column without making its field on the form mandatory. Thanks.
-
Including Half Day Holiday to Timeline Nonworking Day
Is there a way to add half days as a holiday in a timeline (nonworking days)? EX: We are having a half day on Friday and Monday off for Memorial Day. I was hoping to find a way to include in this in the timeline (nonworking days)?…
-
Populating a Dropdown List
Hi, is it possible to populate the contents of a dropdown list from another smartsheet?
-
Can an email template be built in Smart Sheets that is sent out to a DL?
Can an email template be built in Smartsheet that can accept free form text in certain fields and also be able to be emailed out in the G-Suite to a DL. The other condition would be to be able to reuse the sent email message and be able to send subsequent email updates using the same email thread in the G-suite. Not sure…
-
Using Index Collect formula when there are multiple matches in the source sheet. (#Invalid Value)
Hello, My goal with using INDEX(COLLECT)) was to obtain information based on 3 different criteria, but in my source sheet there are multiple matches for the three criteria specified. What do I need to add to the Index, Collect formula to overcome this or do I need to use a different formula combination? Below is the…
-
Can you use superscript or subscript?
I found an ancient post about superscripts from like 2016 where developers noted they would add this to list of enhancements. We use a lot of larger scientific numbers and need to have superscripts, even if it's treated as text vs. a number. I'm certain we are not the only folks using Smartsheets that would benefit from…
-
Username Confusion for "Modified By"
I am tracking 400+ projects in a smartsheet that get updated via 25+ reports tailored to filter by project owner. For integrity monitoring I have a report that tells me changes made by timestamp and username using the Created, Modified, and Modified By system fields. My smartsheet has automations, forms, and cell formulas…
-
Automatic Workflows for Sub Tasks
I am working on updating our engineering change request (ECR) process and we are moving the tracking of this process to Smartsheet. Each ECR needs a variety of things from a few different departments to be complete. Right now the process starts with a form that anyone can submit. New ECRs are reviewed by a Change Board and…
-
Offline forms
Are there any ways to set up the ability to create online and offline forms for off-site locations where internet connection cannot be guaranteed?
-
Space to view Product Enhancement Requests
Hello, I'm new to Smartsheet and surprised to not find (at least not easily) a space to view Product Enhancement Requests submitted by other users (and soon to be myself). I've found several folks asking for certain features in community posts and they are directed to submit a form. I don't want to duplicate a request that…