-
Cell Reference Limitation
We're tracking different divisions within our company on separate sheets. We’ve created summary sheets that reference other smartsheet tabs and we’re consistently hitting the 100 distinct cross sheet references limit when building summary sheets. We figured out how to compile the information for each division via the…
-
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?
-
Is there a way to have the rows automatically sort ascending by date when new rows are entered?
I have a job board created that jobs are added to and dispatched from the problem is if the jobs are not ented in order by date then I have to manually sort each time. This is a 24/7 process mostly accessed by mobile devices so sort is not an option.
-
if formula
Hi, I'm in need of a little help. I am trying to create a spreadsheet that allows me to calculate the reimbursement amount. For instance, if the employee returns a receipt over the allowance amount then the total would be the allowance amount. If it's less than the allowance amount then it equals the receipt amount. It…
-
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…
-
Checking what Months are during a Project
Hi, I've tried to find a solution for this, but maybe it's a too generic wording problem. We have a Master Project list, that has the start and end date of every project we have, as well as it's budget and projected profits. I want to have an overview of how much money is allocated to each month and for that I need to…
-
Error message - publishing SmartSheet calendar to Outlook
I played around with the publishing calendar functionality using ICal and syncing it to my Outlook account. I eventually decided not to use this function and turned it off in SmartSheet. Several times a day I am getting an error message in Outlook related to publishing the calendar. See the attached screenshot. Any ideas…
-
Conditional Formatting Not Working
Hello, I've set my CF rule to look like the screen shot I have attached. I've been over it for what seems like 100x but it's just not working. Can someone please help?
-
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.…
