-
What is wrong with this formula please
=COUNTIFS([Player 1]15:[Player 5]53, Name@row, Role15:Role53, Role17)
-
Best Approach for Forecasting Resource Availability in Smartsheet?
-
Resource Management Badge
How about a Resource Management module badge? It would be helpful to identify those who have knowledge of it.
-
Redefine a formula for status and date
Changes needed to my current formula. There is just too much going on, I want to simplify this. My current formula in the "Certification Complete" is below. Now I also wish to change these colors to words: Green - Complete Yellow - In Progress Red - Not Started In addition I want the Certificate date field to be automated…
-
Dashboards on TV without computer
Hello Everyone. I was wondering how I can show / broadcast a dashboard on a TV without a computer.. Currently we are using a device called Airtame to view the published link on our tv, This solution is working great. However the players can be costly, especially with multiple locations. The only fee is the player itself. I…
-
weeknumber formula
Hi, In Israel our week starts from Sunday, therefore weeknumber formula calculates Sunday for previous week number. I use grid template and even on project template changing Sunday as week start, the formula "weeknumber" presents Sunday as previous week number, pls. see pic below. How can I get Sunday as new weeknumber?…
-
Update Request- Order of items on the update form
I have created an "Request Update Automation", when editing the specific fields to include--is there any way to change the order of the items. Currently the fields are by order they appear on the sheet, can the order be changed without changing the sheet. This would be similar to a FORM created from a sheet, the order of…
-
Brandfolder API Endpoint Deprecation
February 3, 2025 We have determined that a few of our API endpoints are no longer suitable for efficiently searching for assets across users’ Brandfolders. In order to ensure optimal system performance and stability, we are deprecating the following endpoints: Impacted Endpoints: /organizations/<org-key>/assets…
-
Retain my expand/collapse upon save
Per Support, "In Smartsheet, collapsed/expanded row states should ideally persist across sessions. Saving a sheet with collapsed rows should retain that state upon reloading. Parent row expansion/collapse should be controlled by the saved state. For example, saving a sheet with all child rows collapsed should, upon…
-
Power Automate- Add row and cell value from Excel into Smartsheet
I have a Power Automate flow that's triggered when a response is submitted to MS Form. A row is added to an Excel sheet that contains several formulas and values are calculated for the responses. This has been working great, but now I'm being asked to utilize Smartsheet. Rather than recreating the entire Excel workbook…