Smartsheet Basics

Archives for May 2020

Can an Individual user see all places they have been allocated to as a resource?
We have some users that have been allocated to resources, that the admins cannot see. Likely copy of sheets have been made, that has users allocated as resources in them. This prompted the question. Can an individual user See a list of sheets they have been allocated to as a resource? This should be a feature that is front…
Column linking: column "expansion" when rows gets added in source sheet
Hello! I have a Smartsheet where orders are listed, with a bunch of column with all the information. I need to do some calculations based on the orders, for which I need several (30+) helpers columns (automatic scheduling optimization). I find it easier (and cleaner) to have a separate sheet where i copy relevant…
How do I get Checkbox unchecked without loosing it's formula?
I have built a Task Management Sheet (see image) When ticks "Done", I have trigger a workflow approval to another user. If "Declined" I want to set the "Done" field to UNCHECKED To achieve this I put this in the Done Field =IF([Creator Decision]7 = "Declined", 0, 1) The problem is that when the checkbox get "ticked" the…
How do I set Checkbox to "Selected" based on a value of another cell without overriding the formula
I am creating a Task Smartsheet. The "Done" column is a checkbox field. When "Done" is selected, an approval workflow is triggered. If declined, I want the checkbox to become UNCHECKED, however I find that when doing this, I loose the formula that makes the checkbox to become unchecked therefore making the who process…
FORMS - the new functionality of the "updated" FORMS feature is horrible!
My volunteers can no longer SHARE (or send out) any forms. When the "manage forms" window opens, it hides the entire content. I have to open SS on a second window to be able to copy and paste the information that I have to include in my email (web form). When I send out a form, the new program is making me type in a…
Sender of Workflow emails
Hello, we are currently working on an solution where we need to collect input from users outside our organization. While the workflow works fine, emails appear as send from "automation@smartsheet.com". To make it more likely for users to respond to our request, we would prefer it being send from one of our company…
How to transfer a sheet ownership from a user that is not in my organization?
Hello! I'm trying to take ownership of sheets I am the admin of, it gives me the error, "you cannot take ownership of this item because the current owner is not in your organization". My account was part of the parent company business plan, but now our company got their own plan, so my email is no longer part of the parent…
Anyone else have rows moving in their sheet?
Hello all, Just curious if anyone else has had the same issue I'm having and if there's a solution. My company has a master production sheet in order to track Job Orders. Our setup is a parent row which has all the header level information of an order and then the children rows added in are work centers that have to…
I have data in my smartsheet that I don't need all to see, so I created individual reports
I have data in my smartsheet that I don't need all to see, so I created individual reports, but the individuals can only see the titles. How to allow the individuals to view the data without allowing them access to the entire smartsheet?
Is there a way to copy Conditional Formatting from one sheet to another using API ?
I have plenty of sheets per my project and need to apply the same formatting Is there a way to copy Conditional Formatting from one sheet to another using API ?

Trending in Smartsheet Basics

Does the change in value within a formula not count as a change?
I'm trying to create an automation. In this automation, I want to copy rows when a value changes based on a formula (a count from another sheet), but the automation isn't triggering. What could be causing this issue?
How do I update the content that displays when a user selects "Send me a copy of my responses"
When a user submits our form they can select the option to get a copy of their responses. The email they receive has some major formatting issues that need to be resolved - specifically our institution's logo is enormous in the email. Where can I edit the template for people who have elected to get a copy of their…
Core App Certification
Hello, I was planning on taking the Core app certification exam and it says Purchase Required on the page but there is no place to purchase. It also says "Access ending soon" when you navigate to the page with product certifications. Can someone explain what is happening?

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

Watch video<

Smartsheet Basics

Discussion List