-
Setting Up Approval Flow from WebForm
Good afternoon, I created a webform that useres could input data to even though they may not have a smartsheet account. Is there a way for any user to submit the form, and then have it come to me directly for approval before populating the sheet?
-
Conditional Formatting
Hello, Is it possible to apply conditional formatting only in specified rows or does it only apply to the whole sheet? My example is as follows: I am currently tracking production on 20 units. For the first 5 units I do not care if the duration of a planned task exceeds its target. However for the next 15 units, I do want…
-
Notifications and other communication not working
Dear Smartsheet, I had a short presentation of Smasrtsheet functionality and I have faced huge problem with notifications. I have a couple of sheets where all notifications are not sent for some reason. I am trying to play with fields that are triggering these notifications and none of them are working. I have checked if I…
-
Cheery picking data from a sales sheet for customer to view
Hello, We maintain orders for customers in a sales sheet, the columns look something like this; Order Number Customer name Description Manufacturer Order Status Ship Date Delivery Date Sales Value This is our master sheet. So to update our customers we have to look at the sheet and email them important information from it.…
-
How to Trigger Formatting from Comparison / Nested IF?
Hello! I have project sheet, with dependencies enabled. This requires manually updating the % Complete value. I would like to add conditional formatting to remind myself to update the % Complete. IF [Completed]1 is not blank and IF [% Complete]1 does not equal 100% Then Format [% Complete]1 Cell Fill Yellow (screenshot…
-
Moving rows from one sheet to another
We use Smartsheet for our production schedule. The schedule consists of 9 sheets that are all in a workgroup. Is it possible to setup a rule that would allow a row from one sheet to be moved to another sheet using the checkbox feature? Thanks, Jim
-
Colouring Cells using a formula.
Good Day All: I would like a cell to change color (background color) based on a range(See Below). Has anyone used such a formula? My Sheet: https://app.smartsheet.com/b/publish?EQBCT=906e1a0d8f8342e4baead18e6d0a76e4 Overall Rating Score 4.6 - 5.0 (Green) 3.6 - 4.5 (Light Green) 2.6 - 3.5 (Yellow) 2.0 - 2.5 (Light Red) <2…
