-
How can I find all active notifications and workflows in a workspace?
I have a prolific workspace for a completed project that belong to another user who is no longer using the sheets but still owns admin rights. There are still some live automated notifications and line specific update requests being sent from sheets in this workspace. Is there a way to find them to get them shut off…
-
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…
