-
Auto Sort Based on radio buttons
Hi is it possible to move rows and children within the rows to a different sub-category. e.g. we have a purchasing smartsheet which has 3 status icons which are either blank or green for processed for: 1. Ordered 2. Paid 3. Delivered Based on the status of each column i would like to sort the sheet into three categories,…
-
Nested IF/AND Help with RYGB Status Balls
I'm trying to accomplish two things: First, for the "Status Visual" column, I'm trying to state the following formula: * If the "Task Finish" is 3 days overdue, and the "Task Status" is not "Complete" the ball should be red. * If the "Task Finish" is 1 day overdue, and the "Task Status" is not "Complete" the ball should be…
-
Why is my formula UNPARSEABLE? Is it because of Dropdown Dependency?
It's a long formula - I want to make the number of starts in the "Current Status" column dependent upon the selection in the drop down from the "Contract/Grant Status" column: =IF([Contract/Grant Status:]1 = Submitted, "Empty", IF([Contract/Grant Status:]1 = Assigned, "One", IF([Contract/Grant Status:]1 = ELD Review ODE…
-
Conditional formatting based on location in hierachy
Please consider incorporating a functions level() and has_cildren() in the conditional formatting and reporting filters. level() would give "0" if top level and "1","2" ... depending on the number of indentations. has_children() retruns true or false. Combined this would allow: - making filtered reports only extracting…
-
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…
