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
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
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.
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
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?
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
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
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.