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.

Approval request workflow with other cell dropdown
Hello, I'd like to ask this great community how do I make a formula to work with an approval request, upon approved to update other cell in this row, which is a drop-down type for status (has more than 5 statuses). i only like when the 'approved' received to updated status to 'Completed' but until then to have that cell…
Linking cells that are dependent
This is going to be a tough one to explain, and I'm not sure if it's possible. That said...: Endstate: For a finance-based sheet ("Sheet 1"), I want one of the values from a user's form (Amount USD) to populate in another sheet (Sheet 2"). Problem: There is a debiting manager (losing money) and crediting manager (gaining…
Resource Management Settings to Off on All Sheets
It seems that 500+ of our sheets have had the resource management setting on, while our account setting is disabled. We are now wanting to turn it on for just a few sheets. Is there a global update to turn it off on all sheets within our account? Or is this a manual process?
Posting URL's to your project plan in Google drive.
Hello Is it possible to post a URL to your project plan in Google drive in your project folder? I like to organize all of my project documentation or URL's to it in the same folder. Otherwise I will create a Google doc containing the URL I guess? I did see a Smartsheet Sync add on for Google drive I don't know if that will…
Calendar Link
Hi, How can I get an iCalendar Link from a Report's Calendar View? I would like to link my report into Lotus Notes. Any ideas. Thanks,
Send a Form as PDF attached to an email
Hi, Could we have a form generated as PDF in Smartsheet and sent by email to a specific user (email address)? So this user could fill it and send it again. I checked we could have the form sent as link by email, but I need to know if it is feasible to transform it to PDF and send it by email. Any suggestion or solution?…
Cell Linking
Hi all, I have currently set up cell linking, however I only want it to cell link once the drop down box has been changed to 'Converted'. As in, we receive a lead and add the data to that lead. Once that lead is 'won' or 'Converted' I change the drop box to show this. Once this is done then I want it to move onto my other…
Daily Backups
Are automatic daily backups a thing yet? Or is it still only manually?
Count unique words
I have a smartsheet with a list of countries that I would like to total up the number of unique countries in the list? Basically eliminating the dups in the count. For example: US UK IR US CA CA UK AU would equal 5 Total Countries thanks!
Contact list column automation
Hey I have two columns "Admin support" and "Project Manager" in one of my template sheets that I am busy creating. It is a TEMPLATE sheet that will be used in many projects and I need it to be easy for anyone on our large team to use the sheet. These two columns will have the same admin support person and project manager…

Popular Tags

Trending in Smartsheet Basics

Remove workspace shared users from 1 sheet
We are working on setting up our Career Reviews in Smartsheets. We have a group of all staff that has access to all sheets in our workspace. I want to remove them access from just the Career Review Sheets. When I do that it says it will remove them from access to the entire workspace, which is not what we want. The only…
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…

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

Watch video

Smartsheet Basics

Discussion List

Categories

Popular Tags