-
how to receive excel file notification for the newest update in smartsheet ?
Hello, for the current smartsheet, for each new/update records in smartsheet: we receive an email notification for these updates. that is great.., however, in stead of receiving an email with all the new/update records on that email. are we able the send all the update/new records as an attachment - (excel format) via that…
-
Turning flag red with conditional formatting
Is it possible to turn a flag red using conditional formatting? I can turn the cell background red (or any other color), but not just the flag.
-
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
