-
Reminder for every month task
Hi, Every month, we also help our client (around 1000 ) to prepare monthly financial reports and upload their web site. Some of them has specific date required to upload. In SS, we have total 4 sheets. Each sheets represent 3 month(we can't put 4 sheets into one because limitation of SS:, maximum 5000 rows) . We have one…
-
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,…