Product questions?
Ask it here! The community's got your back.

Smartsheet Basics

Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.

Dynamic View... sharing a few initial findings.
1. @mentions aren’t supported. 2. DV doesn’t have a Reporting function built in (ie we need to create a Report form a Sheet before creating the DV) 3. dropboxes show the options but don’t allow to free type a new option, even if allowed in the sheet. It’s also not possible to start typing to fast forward to an existing…
Modified and Modified By system fields not working as expected
I have a sheet I use to keep track of action items. Usual stuff. Long story short, there were some people with action items assigned that no matter how many email requests I sent for updates, they did no get in the sheet to update them. My approach was to create 2 columns: - Modified: Auto/System generated field - Aging…
Links in Dynamic View Work Around
Has anyone figured out a workaround to putting links into dynamic view. I am using control center to create a hyperlink to another sheet with display text (for example "West Coast Project List"). This type of hyperlink does not show up in Dynamic View. I am trying to find a work around and was wondering if my best bet was…
Formula Help IF AND (ORs) and Counts
Hello! I'm attempting to add a formula to my main sheet to prefill a column based on two other columns inputs. So if columns ID Pass/Fail AND NPPES Pass/Fail are "Pass" I want "Pass" to prefill in the column this formula will be in. If there's a mismatch of one Pass and one Fail, or if both are Fails, the row should be…
HELP - Enabling CAPTCHA on a Form
I have a business critical form that's getting spoofed (500+ entries in ~3hrs) and am trying to enable CAPTCHA but I can't seem to get it on the form. Here's what I've done using Edge and Firefox: Edit form > Form Options > Checked 'Enable challenge/response for additional security'
View Cell History not supporting Comments
Hello All We frequently use the comments cell in rows to register and monitor a line items progress over time. This means that some comment threads would have participation by a number of users and over longer periods of time...so far so good However, while it is possible for the comment writer to edit/delete the comment,…
Resource Management
Hi all With the news from May this year about SS acquiring 10,000 ft, I was hoping for some enhanced functionality in Resource Management. Could anyone let me know when this might be rolled out? Many thanks
Concatenate sheet name and cell?
Hi everyone Is it possible to concatenate the name of a sheet, with the Task Name, with the aim of showing it on the Calendar or Gantt Task Bar row? Many thanks Lisa
Web form not refreshing into sheet
I created a worksheet to track issues. I then created a Webform to gather this data from end users. I ran a test entry. I received email with URL to webform. I entered the data and submitted. I received a confirmation message and email. A notice appeared on the worksheet that an entry was made. I click refresh and the…
Color Status Date
I'm trying to make it so the following guidelines are followed from the "Auto Filled in Date" to the "Date Entire Request is Complete/Sent to Law": -Green – An open request that was received 1-5 days ago. -Yellow – An open request that was received 6-10 days ago. -Red – An open request that was received more than 10 days…

Popular Tags

Trending in Smartsheet Basics

Schedule Dates Minus 2 days Except Weekends
I'm trying to figure out a formula. I have a customer that requires a 2 day notice that my crew will be onsite to work. I have an automation set up to remind me to send the store an email 2 days prior. In my "Notify Store" column I have a formula for schedule date -2, but I don't know how to exclude weekends so that the…
PDF Generator Automation Attachments
I've set up an automation to generate a PDF when a row of data is submitted via a form. I have another automation to generate the PDF again each time data in the row changes. I am finding that the subsequent PDF attachment is replacing the first in attachments. Is there a way to have the subsequent PDF added as an…
Inform team on general sheet
Hi, Is there a way, now on a row but sheet level to inform the team whom the sheet has been shared with about modifications done to said sheet. E.g.; I have added locations to a locations column and would like to inform all sheet collaborators on it. Additionally I would like to ask some if moving forward to make a form on…

Help shape the future of Smartsheet.
Share your ideas and feature requests.

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags