-
COUNTIFS nested formula help
I'm trying to get a count for multiple solutions but am getting the '#NESTED CRITERIA' error. =COUNTIFS({Rapid Response Delivery Tracking Range 6}, CONTAINS("Meal Replacement", @cell) + COUNTIFS({Rapid Response Delivery Tracking Range 6}, CONTAINS("Meal Replacement - 2nd Solution", @cell))) Essentially I need it to give me…
-
Power BI Desktop Refresh Issue
I got Power BI Desktop to load graphics into a dashboard. Only problem is that I have to login too often. Is there a way to keep the graphs always open in the dashboard?
-
Calendar App - Filters...why did you change the functionality...now...during a Pandemic?!?!?
Smartsheet, 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 calendar and manually select the criteria that they wished to view via multiple,…
-
Currency conversion based on own sheet
Currency conversion data is saved in one sheet, based on months and years as per our corporate exchange rates. My "main" smartsheet includes my forecast; for reporting issues, it should look-up the PO date and either utilize the latest exchange rate of currency conversion sheet (if PO is forecasted and date is in future)…
-
What's an effective way I can plan my resource's hours for the next recurring 12 weeks?
Right 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 manually input new columns after the initial 12 week period is up. It's a time…
-
COUNTIF Query
Hi All, I'm trying to run a query to group and count certain status' in order to count them as a single statistic. For example: If there's 4 'New / Reported' tickets and the 'Pending External Clariication' has 5 tickets, the OPEN tickets box would show 9 OPEN tickets. Ticket classes: Open ticket = The status' (New /…
-
Smartsheet and Procore Integration
Has anyone used Smartsheet hand in hand with Procore? Background: My company is the design team on a construction project. We are using Smartsheet to handle workflows and documents questions from our subcontractor. The subcontractor is managing the schedule and is using Procore for that piece. Does anyone have any examples…
-
Notifications for adding people to a workspace
I'm wondering if I have something set incorrectly. I have a workspace that I want to limit access to. I noticed today that people with access have been sharing the workspace with others and now I have a ton of people in that workspace. I'd like to get a 'Request to Join Workspace' notification and then approve them before…
-
report: take over colors in grid view of a project
Hello, her's my build. I have a project file (file 1) with all details of different project but always with the same structure with different colors. Out of that I created a second PM file (file 2) with links to that main Project file (file 1). --> Until now all fine thanks to the "link from other cell of sheet" this has…
-
Automatic Breakdown of budgeted hours into cells
Hi all, I was wondering if there is a possibility of creating a formula that would autopopulate cells based on months duration and budgeted hours? E.g. if my study starts in september 2020 and lasts for 10 months, it would autopopulate cells in respective columns? (see snapshot of how the sheet looks) Many thanks