-
SUMIFS for multiple criteria
This should be fairly simple, but I am spinning on this syntax. Trying to sum my "Invoiced" column if the Year Column = "2019" and the Type Column = "Expense". I have tried a few variations, but this is what I think should work? =SUMIFS(Invoiced:Invoiced, Type:Type, Expense, Year:Year, 2019). I have tried quotations around…
-
Images not loading
Anybody else experiencing the problem the last couple days where images on rows/cards don't load? See screenshot. Where you see all those empty boxes within the cards, there are supposed to be unique images.
-
Hyperlink to a network drive
Hi - I have a document stored on a shared network drive that I would like to be able to insert a hyperlink to. Is this possible with Smartsheet? The sheet appears to only accept web addresses as hyperlinks rather than file locations (for example: Z:\Documents\File.pdf). Uploading the document to a cloud storage provider…
-
Number formatting in Sheet Summary
Hello all, I'm using sheet summary to get rid of the top row on our master project list. Formerly, we used "=SUM(CHILDREN())" to add up all projects & sub tasks.The top row was only there to add everything up. We moved this function over to the Sheet Summary & it's working fine. My issue is the number formatting. The…
-
Traffic Lights/cell colour based on corresponding numeric value
Hi, can anyone please help? I want to set up an alert system in SmartSheet that turns a cell green (and labelled 'on track') if a corresponding cell is >90%, yellow ('needs work') if 70%-89%, orange ('at risk') if 40-69%, red ('behind') if 2-39%, and blue ('not started') if <2%.
-
reminder not available at all for automation
Even though I go to Automation and click on set a reminder, I only get the alert triggers. What should I do to get reminders triggers? Regards Pio
-
Network Diagram
Are there any plans to add the ability to display a graphical Network Diagram based on the dependencies? Stephen
-
How to remove hidden fields in tableau sheet while exporting as cross tab from tableau server?
Hi all, I am using Tableau Desktop & Server 9.3. I have created a field named as 'Sales'. There are many other measures and dimensions have been included in sheet along with field 'Sales'. But for some reasons I've to hide 'Sales' field. I've done this by unchecking the option 'Show Header'. I have published my workbook on…
-
JIRA connector set up problem
Hello, we just hooked up the JIRA connector yesterday and I have attained about 90% success with pulling Jira tickets, by epic, into a Smartsheets project plan. I'm having two issues that are frustrating me: 1. Smartsheets is not picking up the epic name from JIRA: field in Smartsheets just says: "Field 'Epic Name' not…
-
Master build schedule to sync with other sheets?
I am not having any luck searching for a solution to this. My company has a production schedule in Excel. It changes daily. Builds get added, removed and moved around on a regular basis. We have two different engineering departments that are managing their work load in Smartsheet. The two departments have very different…
