-
Auto-fill form/cells when a certain item is selected from a drop-down
I was wondering if it is possible to auto-fill cells based on an item that is selected from a drop-down. I am trying to create a form for our subcontractors to upload submittals and I wanted them to be able to select from a drop down list what they are submitting. I.E. Product Data for Paint, or Samples for flooring. Once…
-
How to automatically show a symbol
I have a status column which is a picklist field. The basic values of this picklist are pass / fail / on hold / retest. How can I manipulate the values that I can use in the symbol field?
-
Not a Lisenced Administrator
Hi there I have only tree Lisenced Administrator on my company. I wanted to know... if the other people at the office can be sheet owners for what lap of time? Is there a time limit for them to be sheet owners? Because one of us was been sheet owner but the other day he couldn't do no more. Does smart sheet has some kind…
-
Mandatory Cells
I've done a formula to add "date required" when the box is checked and " " (blank) when date is not checked. Issue is when the user puts the date in the field, it removes the formula, so if they unchecked the check box, or remove the date, the date remains blank. Although I have formatted the cell to stay Red if blank, I'm…
-
Return name of column
Hi, I have a smartsheet with colume names that are acutal dates of a calendar. I am looking for a solutnion to query the name of a specfic column if it has a certain single digit value. (So I get the date back). Any ideals?
-
Conditional formatting not always working on "Modified (Date)" column.
I have a status sheet that is picked up in a Sight. For ease of recognizing updates, I use condirional formatting to change the text color on items modified n the last few days. This worked well initially, but now the formatting is not always being applied. The same text column is updated all the time. Not sure what I may…
-
how to create an "interruption" in a schedule?
We are using Smartsheet as a manufacturing/production planning tool. I've created a sheet format that allows us to do exactly that, with tasks for individuals involving dependencies on other parts/processes. For example, a part is routed to engineering for design, the engineering manager for approval, purchasing to order…
-
Auto-Numbered Column - Conditional Formatting
Hi SS Users, I have a system populated column which automattically updates the date and time a row is amended. I am wondering if there is a way to conditionally format this column? Ie - if the last update was today (any time) go green. All rows with a latest update of anytime before go red. I know how to use conditional…
-
Problems with Smartsheet add-in in Outlook web app (OWA)
When in OWA on my iPhone I click on the already installed Smartsheet for Outlook add-in just above the email body. I then get directed to the Add to Smartsheet window. I then click on the Connect to Smartsheet button, the add-in seems to want to load but then stops and shows the Add to Smartsheet window again as if nothing…
-
$ per month formula
I am trying to put together a formula to track the amount of money we are bringing in per month per project. Not sure if I am doing it right... Any help would be appreicated. Here is what I am coming up with so far - =IF(Phase30)= "Construction", [Estimate $]30/Duration30) I know they duration is only calculated in days -…