-
Weekly Update Text Column
Hi Community— Need some advice. My team uses an Excel spreadsheet to track account updates. Weekly we add a column to the right and the team inputs a paragraph of text. So the existing Excel sheet is up to column "AH" since we are at calendar week W42. So next week ... "AI" and so on. The previous week's column is then…
-
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…