-
Import and Export Conditional Formatting Rules
The possibility of being able to clone rules across sheets has been mentioned before in a couple of posts, but I want to raise the issue again because of an incident that occurred last Friday. A key Smartsheet with over 100 conditional formatting rules (123 I believe, according to the Activity log) lost them all. Hopefully…
-
Automatic Cell data input..Formula???
I am polling permission via web form from 150 of our top accounts. The web form will only collect client info they would know, such as their name, account name, email, contact # and yes or no for permission. However, on our end, when that entry comes in, I need other internal info to auto populate based off the "Account…
-
Copy Rows Between Sheets Based on Checkbox
I am trying to create a calendar or events based off a master list of events on another sheet. The source sheet is a master list of all possible events. That sheet contains a column of check boxes. When a checkbox is checked I would like it to automatically copy that row from the source sheet to the destination sheet. The…
-
Copy Column Properties
Hi, I am creating a new sheet that needs to have 20+columns that are all a dropdown column type, with the same dropdown responses. Is there a copy function for setting up the columns? Thanks, Lisa
-
Column Properties: Not Able to Select Any Standard Option Other Than Check Box
Hi, I have a project queries management smartsheet and one of the Column Titles is "Done". I had chosen "Checkbox" as type of COLUMN PROPERTY. Now I have changed my mind and I want to change the COLUMN PROPERTY from Checkbox to DROP DOWN list. When I right click on Column Heading, I don get EDIT COLUMN PROPERTIES option to…
-
Posting/Including data from another cell.
Within my sheet I have two columns that contain time (hh:mm:ss). In the third cell I am comparing the two columns. If they do not match a statement is posted in a cell stating something is wrong. What I would like to add to the statement is the value from one of the cells containing the time. This works, with no added…
-
Template Management - Updating Active Projects
Greetings, I saw an older post similar to this subject - but I'll open this one to hopefully garner some fresh information. I use a Template that I've built to start new projects (sheets). On occassion, I'll learn some nifty new feature or functionality that I'll build into my master template. That's great for "from here…
-
Updating RYGB status based on date AND dropdown selection in multiple columns
Hello! I would like for the RYGB status to be updated based on BOTH a due date (I already know how to do the status based on only due date), AND on the selection of a drop down menu in 5 other columns. So: Red is past due AND "completed" or "N/A" are not selected in the drop down menu in multiple columns. Green is past due…
-
Cell Formating
I would like to be able to format individual cells - what is the easiest way to do that? For Example - I have months listed with the forecast for that month and I want the cell font to be red if the forecast goal was not met. However, further down the column - the forecast goal might be higher.
-
Conditional formatting not sticking to exported PDF
Hi, I have a report that looks perfectly fine when viewing in Smartsheet but when exported to a PDF it throws in a grey fill. There is a conditional formatting that specifically says if the "Resource name headers" column is blank, keep that cell white - and it's a higher priority than everything else. Why is this happening…