-
Combining multiple SUMIFS into one formula
I have used and tried each of these formulas separately and they work beautifully. =SUMIFS([Total Savings]@row, Lane@row, "IL5" =SUMIFS([Total Savings]@row * 90 / 100, Lane@row, "IL4" =SUMIFS([Total Savings]@row * 50 / 100, Lane@row, "IL3" =SUMIFS([Total Savings]@row * 10 / 100, Lane@row, "IL2" =SUMIFS([Total Savings]@row…
-
New Multi-Select DropDown Buggy?
Has anyone else experienced the newly-released multi-select option being buggy? I seem to have 50/50 luck when I attempt to select from the drop-downs when it wont display drop-downs. I thought it might have just been me but then I had the (not) wonderful experience of showing my VP the new feature when it didn't work on…
-
Generate reference after box ticking
Hi all, Been trying to look for my solution here, but i can't seem to find it. Hopefully someone can help me. I have a supplier approval database with supplier info, several checkboxes for required docs, etc. Also have an approval column, and then an approval reference column. What i intend to do is, when i tick the…
-
An Error has occurred in Smartsheet
Dear Smartsheet team, One of our main production management sheets cannot be accessed. We logged out, logged in, restarted browser, cleared cache, computer, etc. The message is: An Error has occurred in Smartsheet It can not be accessed by web or mobile device across all our users. Please help urgently, our daily…
-
Link to a Dashboard in an automation alert
I am sending out alerts based on a cell being changed. I would like to customize the email that gets sent to include a link to a related dashboard. Is there a way to make this a hyperlink that can just be clicked to take them to that dashboard?
-
Losing Data & Slow Performance
Hi, just recently my Smartsheet is going really slow, and I'm losing information I've just entered. I can't drag information from one cell to another, and can take 3 seconds or longer to load information, and half the time the file doesn't actually attach. I have to close down and reopen Smartsheet all the time so it saves…
-
Filter Organization
Does SmartSheet have any way to organize filters? I have a large sheet where everything falls into one of five categories. There are then ten sub-categories for each main category. I would like to create filters for these 50 combinations, but I don't want to have my team users scroll thru 60+ filters. Ideally I would put…
-
Roundup causing error on reports
Hello, I added the new roundup formula to my sheet and this cause all of my reports that reference this column to show up as #unparseable only on the report. This shows as a value on the main sheet. To make this worse any other formula on this sheet shows up as #blocked until this is removed
-
REFRESH A SHEET
I linked two sheets (A and B) On sheet A are the name of customers from all country with other informations about them. Sheet B is the active sheet, I choose a country in a cell with a dropdown list. On other cells, I use VLOOK link to the dropdown list cells. Finally, by choosing a country name in the drowdown list I have…
-
Export Entire Folder to pdf and include gantt charts
Hello, I like how the feature to export an individual sheet to a pdf view gantt chart view. However, if you try to export several sheets from one folder, the gantt charts will not show. I would like the ability to export all sheets into one document that will display gantt information. Thanks in advance on possible…