-
Parent/Child Row Formulas
I have two questions... First, I am trying to sum all the values in a column so that when I sort by a specific column the formula does not get all jacked up. Second, I have another sheet where I trying to sum the values in the child rows to the parent row. I understand how to do that but everytime I sort the sheet on a…
-
"Processing" Today date in date range.
Good day all, I am collecting information via a webform and need some assistance with the reporting side of things. On the webform i am asking among other things to provide me with a startdate and a finishdate. My aim is to have automated reporting in the backend that will check if date Today is in range of the user…
-
Dependency Settings
i am trying to build a construction timeline for a project. and i need to use different dependency time frames for different vendors in the same spreadsheet. for example: Permitting works on a business work week schedule. so Mon-Fri no weekends and no holidays. However the GC has agreed he wiil complete his work in exactly…
-
Smart sheet as CRM
Hi there, We are in the process of a new enterprise, and really love using Smartsheet, especially the history function. I’m looking for a good CRM cloud software, were I can easily manage contacts, pipeline, promotions, billing, INV, inventory etc. I think Smartsheet is perfect for pipeline management, but I miss the…
-
Historical Report Status
I am looking to increase my efficiency when creating statistical reports. Each week, we run a report to see how our projects are tracking (red, yellow, green traffic lights) but I what I want to do is keep each weeks statistics so that I can create a historical report of these figures. At the moment, each week I need to…
-
Dropbox and Desktop Version (Chrome App)
In the chrome app (from the desktop link) attachments from dropbox is not an option, while it is on webversion. Any solution?
-
Cell formatting in reports
When I copy a cell and then paste to another location in a report, the formatting is lost (bold, text color, strikethrough, etc). It would be nice if some of the cell formatting options were available in reports. Not only for copied cells, but it could be used for changes to cells as well. I have occasion to use reports to…
-
Transfer of account
Hi all. I have a client whom I am configuring some sheets for. They would like me to invoice them for the configuration/consulting service AND the Smartsheet licence. They dont have access to a company credit card for the in-app upgrade so wish to just pay me to buy the licence for them. I know that we can change…
-
Using the Sheet data widget on Sights
Hi I noticed that the above widget says that I can copy a range of cells but I haven't figured out how to select multiple cells in a row (not next to each other) and also how to put multiple rows (not next to each other). Is this possible?
-
for one project today all task lines over 1 line height do not show the same height in the task numb
here is what I see, it only applies to one of my projects and I logged out and logged back in to smartsheet and the problem persists. Causes problems when I want to update values in columns to the right with the input box, for dates for example appears 5 lines above where I am expecting it to
