-
Is it possible to visualize Power BI data in SmartSheet?
Our company utilizes Power BI to track project dates and we'd like to be able to auto-update these specific dates into a SmartSheet sheet based on similar project numbers used in both systems. We want the dates imported from Power BI into SmartSheet, not SmartSheet info into Power BI. Is this possible? Thanks!
-
COUNTIF & Multi-Selection Dropdown -- Count multiple entries
My data input sheet has several columns that are Multi-select dropdowns. For my Metrics summary page, I am struggling with COUNTIF when the user has selected multiple options. Example of options in the Multi-selection dropdown: * Apple * Pear * Grapes * Banana * Other I need guidance on how to structure the criteria for…
-
Dynamic Forms
Hi, I'm trying to create a form that is dynamic wherein the other fields will changed when a certain category is picked. For example, selecting category: printing project that will have how many pages, if it's double sided and what type of project it will be. Then another project that selected category: Room Setup request…
-
Application Engineer uses Smartsheet to manage fast moving projects
Hello yall! I am an application engineer who uses a simple Smartsheet to keep track of all the projects that I am working on. Previously I would rely on folders in outlook to keep separate projects distinct, however Smartsheet allows me to see what I am working on and what I have finished!
-
Formula Help Within Sheet
Alright, SmartSheet community. You've always been good to me with helping out. I've got a real "stumper" here. Let's say I have six columns on my sheet (in reality there's many, many more; but these are the ones relevant to my question): Start Date (a Date/Time column type) End Date (a Date/Time column type) Allocation %…
-
Smartsheets Budget Forecasting
Hello, I am trying to create a custom sheet. It would be a calendar with a nested daily budget. For each day of the week we would be able to update the expenses or add budget forecasting. It should also show the running monthly and yearly total.
-
Merged: Kanban Grid
This discussion has been merged.
-
Project status synchronization between 2 sheets
I have 2 sheets (2 project trackers) and need to present the status in a "master" tracker based on a data from the "slave" one. The problem is that in the slave there could be couple (even 20) rows that are connected to the one project in the master file. They are connected via Project Name column. I need to somehow merge…
-
Auto Refresh for Reports
I'd like to request Smartsheet look into adding the "auto-refresh" feature, currently only available on Dashboards, to Reports. We use reports to filter columns for individuals in teams that share a sheet, but who don't need to see all the columns on that sheet. This works well, except the user is forced to save and…
-
Prevent Sorting on Shared Sheet
We have a lot of users using Smartsheet as a tracker. Team members sort and then filter to get the information they need. The problem is that the sort affects all of the other users who are sorting on different things. Is there a way to have the sort only apply to the user that is sorting? Similar to the way that filters…
