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.

How to do "OR" in conditional formatting
Hello, I have a column which receives answers from a form. The form is basically a test for nurses. I have conditional formatting set up in the answer column that if the answer arriving is NOT the correct answer, then the cell with the wrong answer turns red. Now the managers decided to change the wording in one of the…
Incorrect Argument Set
Hi All, Trying to figure out why I'm getting the Incorrect Argument Set with the following formula. Works fine with most rows, but gives the incorrect argument set when the Date Requested By School is less than or equal to 14. I tried adding that in to one of those rows, thinking it was missing a component, and still got…
Duration in Hours and Minutes
Greetings, I have certain subtasks under my tasks that only run terms of hours and minutes and not days. Is it possible to capture the duration in that detail ? Or do we need to break down the days in to hours (which seems very tedious). I did find on this…
Allowing multiple contacts per cell leads card view is removed.
Card view is removed automatically when changing configuration of a contacts type column to multiple contacts per cell. I need that card view.
Predecessors (Finish to Finish & Finish to Start
I may have a basic misunderstanding & need some clarification. I have a task #3 (the Effective Date) of a contract. Further down the project I have another task.... #20 - Purchaser obtains an updated Survey & Title Commitment. Task #20 can begin on the Effective Date (task #3). Further down the project I have another task…
Column labels?
Hello all! I am brand new and have no idea what I'm doing yet. lol! I was wondering, is there a setting that will label colums like in Excel (A,B,C etc). I can't tell if a column is hidden just by looking at it. Thanks in advance for your help! Jennie
Back dating
Hello, I am looking for instructions on how to get smartsheet to backdate. For example, I have a due date for a project and I want it to create auto create internal dates based off that. Essentially the end of the project drives the internal deadlines. I am set up to know how long each step takes in days and I was…
You have been blocked
Has anyone noticed that Cloudflare is blocking people trying to access smartsheet.com lately? what's up with this new policy? It also is doing it on the forums every time you try to add an image now.
Time Stamp
Is there a way to "TimeStamp" a row when it is Initially Created?
Unable to Access File
Everyone in our company is unable to access a file that we have created ourselves. The attached error asks that we Request Access but no one is getting an email. Is there something else I can try? It is a document that has not been accessed in a few months. Would it be deleted after a certain period of time if that's the…

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