-
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…
-
Backup fails with error "SSLPeerUnverifiedException"
I'm running backups daily on the smartsheet using the java backup utility. For the last month or something the backups fails. This is the error I Using properties file: C:\smartsheet\smartsheet-backup.properties ***ERROR*** SSLPeerUnverifiedException - peer not authenticated javax.net.ssl.SSLPeerUnverifiedException: peer…
-
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…
-
Smartsheet Sights - Minimizing views
We have 200 users using approximately 50 sheets and have found the view very cumbersome for the users to scroll through a list. We have created a smartsheet "site" (using the site feature) linked to other "sites" that emulates a web base design. Where we are currently stuck is that we are looking for a way to direct our…
-
Formula for SumIf
need formula for adding total from column if it meets the criteria from another column =sumif(Division4:Division16,LSG,[Q1 AOP]14:[Q1 AOP]22)
-
Update Request - Create New Request Button in grayed out on my form
I am unable to create an update request
-
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?
-
How to show date and an amount in same column
This may be an easy one or maybe not be able to be performed. I have a column that is showing the current total for the project . is there any way of showing the date in the cell as well as the amount in the same cell? or would i just need to add another column next to this one to input the date and change it when i change…
-
Can one Site call another Site
We put on events and each event has a sheet and a Sight. I have created one Sight with information from each of the event sheets, but I want to drill back to that events Sight and not to that events sheet. Is there a way to do this?
-
Run report for current month
Let's say my task sheet has dates that tasks are created - not necessary TODAY. And I want to run a report if the created date is this month. For example, Task A's created date is 09/10/2017, and this month is September. The report should pick up Task A if I run report today, but next month. How can I achieve this? I made…