-
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…
-
Inconsistently updating Latest Comment Column
New conversations sometimes immediately populate to the Latest Comment column. Other times I need to save & refresh browser which works inconsistently. My last resort fix is to copy the new conversation, delete the original and then save a new conversation which then updates to the Latest Comment column. Anyone else run…
-
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…
-
Unhide specific columns on a sheet
Instead of unhiding all columns to find one or two that are needed, it'd be great to be able to unhide specific ones, like Excel does with Tabs.