-
countif help
Hi all, I'm trying to figure out a way to sum the number of one column if it has the value of another column. The formula I was trying is: =COUNTIF(Scoped:Scoped, Channel22) I want to know how many are scoped in the scoped column if the channel header is in row 22. It's reading invalid. Any other ideas?
-
Enhancement Request: Filters to include and / or functionality
I would like to request the ability to customize filters by adding specific conditions to each row. The filters currently have an option to show rows that match all conditions or an option to show rows that match at least one condition. Because we share our SmartSheets with multiple teams, I would like the ability to add…
-
Linking to a sheet from a report
I have a report that pulls task from several different sheets. I want to create a link on the report so that I can easily click on the task and it will take me specifically to that sheet that the report is pulling from.
-
Calculate days since a bubble turned red
I have a column that shows red (off track), yellow (at risk), or green (on track) depending on whether a date column (completion) is before or after another date column (goal completion date). What I'd like to show is the amount of days since a bubble turned red. This would tell me how many days it has been since a project…
-
How to get back to previous version of android app?
Hi, Does anybody knows how can I get previous version of android application? Latest update is great, but it changed some main rules of how reports behaves in android phones and I have no idea how to sort it out now other than go back to the 4.2.0 version. That version allowed users to open row details in kind of separate…
-
Custom colours in Dashboard Charts
Is it possible to add your own custom colours to charts in Dashboards so i can produce charts in my companies branded colours?
-
How to show more than one month on calendar view
I am wondering if there is a way to show more than one month on calendar view. I am working creating an HR sheet and I need to be able to see the last 12 months if someone took a vacation. Also is there a way in a column to have more than 1 date so for example if someone took off both June 5th and then July 8 can we put…
-
Auto Status Change/Update
Hi, I am trying to create a tracked schedule and was wondering if smartsheet had an option or setting that auto updated status based on the date entered and real time date. For example if a phase is due at 08/24/2018 and it is 08/25/2018 and the status box of completion is not checked yet, is there a way to create…
-
Milestones in Report not printing to PDF correctly
I have a report that shows milestones and tasks. When I print to PDF the milestones are not showing as milestones but as very thin tasks. This is odd as the report shows a diamond black milestone but the problem occurs when I print to PDF. Any suggestions?
-
Export of reports do not properly show diamond
Hi there, When I make an export (gantt to image) of a report including a few milestones, they don't get exported as diamonds, but as 1 day events. Is this a bug? Because when I look at the Gantt view in Smartsheet itself, then the diamonds are displayed correctly. Thanks!
