-
UK Contact - Issue with account
Hi, does anyone have a contact number in the UK that works? my account & my whole company is locked out & asked to upgrade when we already have.... this is very urgent!!!
-
"Dashboards just got better"
Has anyone had any success creating a chart with nonadjacent columns following the recent communication that the charts have more options?
-
Struggling with If statement
I am trying to create a formula to check a box in one column if a date in another column is greater than a specific date. Here is what I have, that is not working: =IF(ISDATE([Estimated Close Date]1), IF(AND([Estimated Close Date]1 = >DATE(2018, 6, 1), 1))) Estimated Close Date is a date column. The formula I am trying to…
-
Autofill based on the new entry in another sheet
I run constantly to the same problem and decided to shout out for help. Basically my problem can be defined as cross sheets conditional autofill. My case: Sheet 1 (offers) - sales people add data about new offers with the web form (that's OK) Sheet 2 (orders) - I need to bring data from the sheet 1, if offer's status is…
-
Nested CountIf statement help needed
Hi, I need to create a formula where if a box is checked in one column, a figure in another column gets included in a sum in another cell at the bottom of the column with the numeric value. This is what I've got, but I'm getting error messages: =COUNTIF(QTR:QTR, "True", SUM(Blackline:Blackline)) I'm not sure exactly what…
-
Report with contact details
Hi, I want to create report with contact details based on data from my sheet. The problem I have is that in sheet I have some duplicates. Is there a way to add only one of duplicates to the report?
-
Formula with Update Requests
Hello all, Im using Smartsheet to automatize a lead process with around 30 people involved. We get Leads in an external network, I add them to my Smartsheet Sheet and then the one in a contact column gets an automatized notification with the new lead data. After 5 days I need an update with est. values and so on, so I made…
-
Totals By Date
Hello, Has anyone successfully used dates to pull totals? I'm trying to do the following: Columns: Start Date | End Date | Status 1/2/18 1/10/18 Completed 1/5/18 1/7/18 Completed 1/5/18 Open 2/8/18 2/15/18 Completed 2/16/18 2/20/18 Cancelled Output: Total 'Completed' for January 2018 = I'm wanting to use the dates and…
-
Filtered Views for External Collaborators
Hello, i am not sure what the best way is to accomplish this. I have a smartsheet that i would like to collaborate with outside vendors. I would like to avoid chopping up the data and giving every vendor their own sheet. I will be adding new data weekly. Update request won't work because they could be getting 20+ lines at…
-
Unicode character to allow blank rows in forms
In the spirit of sharing, I thought I'd let you all in on the Arial Unicode Right-To-Left Mark character that can be used in forms to add blank row between Help Text and the form value. As per the image below: * begin by selecting and copying the U+200F character from the Arial set in the Windows Character Map application.…
