industry
Discussion List
-
Display Logo at the sheet levelIn Using SmartsheetHi, is there a possibility to display 2 logos at the sheet level? I know that I can include a logo image to the workspace and that will replace the "smartsheet" logo from all files within that workspace. But what I am trying to d…
-
Dynamic Data Validation with Columns from another GridIn Using SmartsheetHi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that …
-
MicrostrategyIn Apps, Integrations, and Add OnsHi all, I searched and I didn't find anything for this so I am hoping I did not just miss this. We are trying to tie our data into Microstrategy for more visualization options. We are using the Live Data Connector. Has anyone been able to …Answered - Pending Review 235 views 2 comments 0 points Most recent by Liz Beall Apps, Integrations, and Add Ons
-
SUMIFS and Referencing Another Sheet (Financials) = INCORRECT ARGUMENT SETIn Formulas and FunctionsHello all, I'm trying to compile some financial totals for various departments into a Metrics sheet for Dashboard reporting and something is not going right. I can get the total for all departments from the referenced sheet with =SUMIF({To…Answered - Pending Review 67 views 1 comment 0 points Most recent by Paul Newcome Formulas and Functions
-
Gov connection in Power BI?In Apps, Integrations, and Add OnsIs there a way to make Smartsheetgov data available in Power BI? The existing Power BI Smartsheet app/connector only seems to connect to a Smartsheet account, but not a Smartsheetgov account, and I don't see any way to customize it to cha…
-
No AVERAGEIFS so I tried AVG(COLLECT) but can't get it to work with multiple criteriaIn Formulas and FunctionsHi, I'm trying to calculate the average of the operational speed [plants/h] only if the [job type] is "Grafting TOM" (cells highlighted in yellow) and also IF [week NO] is a certain value: so basically the average speed for each …Answered - Pending Review 440 views 2 comments 0 points Most recent by Genevieve P. Formulas and Functions
-
How do you extract numbers out of a cell and create a chart with the dataIn Formulas and FunctionsHow do you extract numbers out of a cell that is formatted in a 12-hour clock and paste the numbers into another cell? I need the column "Time Duration" to know the difference between the "Start Time" and "End Time…Answered - Pending Review 57 views 3 comments 0 points Most recent by FugroKyle Formulas and Functions
-
Calendar App - Filters...why did you change the functionality...now...during a Pandemic?!?!?In Apps, Integrations, and Add OnsSmartsheet, Before I lose my mind, here... please tell me that there is (at the very least) a way for individual users to create filters without being shared to the underlying sheet. Up until this change, our users were able to access the …
-
What's an effective way I can plan my resource's hours for the next recurring 12 weeks?In Using SmartsheetRight now, my management asks PM's to predict how many hours their resources will be spending on a given task (tasks = rows) per week (1 week period = 1 column)? What's a possible more efficient way to do this? At the moment, we have to ma…
