I have loads of sheets in a "project" folder, 1 for each project, which have identical layout (column names etc).
Each sheets has a region field, which is either UK, China, Japan, HK or Multi.
I then have reports which take the relevant information I need from all sheets in the "report"
I have a webform that collects data for a request, Department, Type, Etc. These are separate columns. I would like to somehow filter the some of the information received into one column, which would then be a code for that particular request. The code is then used in other locations as an
I'm missing the ability to insert data into Sights based on specific fields or ranges of a report. Currently one can "only" insert a report as a whole.
If you want to show certain fields or ranges like with the metric widget or sheet data widget it is only possible to pick them from sheets, not
I have created two sheets for our company travel planning, one is a budget planning sheet, and one is a trip strategy sheet. There are hyperlinks to jump between the sheets, and cell links to transfer data from sheet to sheet. When I make the daughter sheets, I would link the links to
It'd be handy to be able to add a pattern overlay to Gantt bars. Like these: http://www.webdesigndev.com/wp-content/uploads/2015/02/20-Repeatable-Pi…
The use case for us is that we want to color code our bars for who the'yre assigned to, but be able to label some of those bars as having a "fuzzy"
New to smartsheets I have been using excel extensively. Can someone pleased teach me the formula for finding a quarter based on a date?
For instance [Date Data Column]1 = 1/1/2016 I want the formula to return "Q1" in the [Quarter]1 cell
Havent been able to figure this one out...help
I unable to enter the application, it keeps saying "smartsheet is loading ..." The problem started for me about an hour