-
Creating a heat map to understand level of effort across a team
Hi! We would like to understand which projects are requiring more effort, by week and by person (i.e. where is the team spending most of their time this week). The challenge is that the sheet is designed for comms plans vs. project or resource management, so duration isn't an accurate indication of time spent. I included…
-
How to use multi-select dropdown list as criteria for sumif/vlookup
Hey guys, thanks in advance for you help. I have three sheets that I am working with: a database (of sorts), a grid-form summary sheet, and sheet that contains attributed values. To simplify, I will only use a, b, c, and d as production point names and whole percentages as attributed values. The "database" contains unique…
-
Rolling Negative Status Up Hierarchy from Children
Hello, I am working to streamline my project timelines for quicker daily tracking. I currently have a formula based on the task completion % and end date that gives a status and conditional formatting for the negative statuses: "At Risk" & "Late". It works great at the lowest level, but I am running into issues where I…
-
Can you create an order form in Smartsheet
I am wanting to create some order form for my company, but i cant seem to be able to create a section where they are able to put in more than one product at a time. What colunm type would i use?
-
Hello how can I produce percentage through the reports Data that are not percentage
for example - I have 5 employees who fill in online forms and I have to produce a report from all forms that will be divided into a percentage according to each employee Michal - filled 5 forms yoni - filled 5 forms total of 10 forms which means that each one of them had 50% work. i want to show it on the dashboard as a…
-
Formula for counting how many times a cell has been updated
Is there a formula that you can suggest that will count the number of times a Date has been updated in a specific cell? For example; if I have a date of 4/1/2025 and I update it to 4/21/2025, I would expect to see "2" in a cell titled "Number of times date updated". Delays can happen for various reasons and I would like to…
-
Allowing combining Dashboards into one Dashboard, allowing users to create their own landing page
I have dashboards built for different groups, but some of the people in the two groups work in both, and it would be really great if users were able to combine dashboards for personal use, without having to build three separate dashboards. I guess I'd like a "Dashboard Home", where the user can select from their existing…
-
Moving Comments Between Sheets
I am looking to find a method to copy select columns in a row along with the row comments from one sheet to another. Methods that I have tried and will not work in this scenario: Copying the entire row from Sheet A to Sheet B (This brings over all columns and I am only looking to copy over select columns) Using helper…
-
Merged: Update functions list to include regular expressions
This discussion has been merged.
-
Report data not visible to those with access
Anyone else experiencing this just recently? I have a handful of people not able to see Report data (some or all - depends on the report and it's happening on a ton of them) that they should be able to see and have access to? It's not an access/ sharing permission issue. There is not a current user filter on the Report.…