-
Enterprise account new feature: Notification Center
Hi, Recently, there is new feature for enterprise account. Notification Center. So, even I do not open the email, I can know the notification I receive. My case is I have SmartSheet and set up 2 notification. Each notification will involve 30 accounting managers. My question is does notification center has the feature so Iā¦
-
Notification when new State is added to list - unique list
Hi, I need to create a notification when we have an order shipped to a State we have not shipped that product to in the past. The client's State is automatically added to the sheet from a workflow, and I need to get notified when ever we have a new State added to the list. I think one way to do is this is to create a newā¦
-
Simplifying my formula
I would like to simplify a formula (if possible). Several items in the formula below have the same value (e.g. 25 or 10). =IF([Activity_1]1 = āJTAā, ā25ā, IF([Activity_1]1 = āIDWā, ā25ā, IF([Activity_1]1 = āLab Buildsā, ā25ā, IF([Activity_1]1 = āTRā, ā20ā, IF([Activity_1]1 = āVCDX Defā, ā15ā, IF([Activity_1]1 = āVCDXā¦
-
Nested IF Statement Limit?
Is there a limit to the number of nested IF statements in a formula?
-
Adding to an Existing Conditional Formula: Date Field
Good Day All: I am trying to add to my existing formula if theĀ date is not populated the harvey ball will remain yellow. If all conditions are met (date submitted, date approved, approved by committee, and Delivery date) then green All help greatly appreciated, Thanks! Existing Formula:Ā =IF([Approved by Committee]2 = 1,ā¦
-
How do you display a chart in the dashboard/sights?
Does anyone know how to upload a chart in smartsheet labs onto a dashboard/sights?
-
In Application Alert Notifications without email?
Now that we have the alert notification alert in the top right corner of the SS application, is it possible to have that show the alerts but to not receive an email? I'm in SS all day so I see the alerts and view them in the system and then just delete the emails they generated later. It would be nice if the deliveryā¦
-
SmartSheet Adoption
I am sharing with approximately 80 users and about 15% actually login and look at the dashboard, click on issues, risks and attachments - never mind download the attachments. Has anyone experienced this resistance to adoption before and if so, how did you overcome it? Thanks, Karen
-
Only part of the formula working ? Top Half
=IF(SUMIFS([Value of Jobs]25, [Assign Too]25, "Heath Sanders", Status25, "WON", Result25, 1, [Sold Date]25, IFERROR(MONTH(@cell), "") = MONTH(TODAY()), [Sold Date]25, IFERROR(YEAR(@cell), "-") = YEAR(TODAY())) = 0, "", SUMIFS([Value of Jobs]25, [Assign Too]25, "Heath Sanders", Status25, "WON", Result25, 1, [Sold Date]25,ā¦
-
Using LOOKUP function on a sheet with a form to add rows
I am having some trouble with using the LOOKUP function on a sheet I have. We want to use a form to create a ad placement name that includes abbreviations of what the user selects. I am finding that the LOOKUP area shifts as new rows are added. I set all my lookup tables at the top of a sheet and then the new rows areā¦