-
Using SUM with child rows
I have a parent row that I'm using to sum all child row values where Children = 0 and Status = "Not Started". This is my formula. =IF(OR(ISBLANK(Status@row ), Hierarchy@row = 0), "", IF(Hierarchy@row = 1, SUM(CHILDREN()), IF(AND(Children@row = 0, Status@row = "Not Started"), 1, 0))) However, if any of my task rows are…
-
How to optimise my currentTimesheet solution
Hi community, hope you are all spending a great xmas period. I'm here to ask you advice on how i could improve or change completely the architecture of my timesheet solution. I have setup up a sheet with the following main columns: Work date - Contact - Project Name - Activities A total of 15 users enter their activity…
-
help with auto numbering my projects that have children and grandchildren
I want to assign project numbers to the main project, and then append that project number with .(letter) for the Subprojects, with Tasks still being assigned to the main project number, with the letter of the Subproject, and adding more hierarchy, such as I'd like the task to read 40.c.1, or something similar that…
-
Using AI and Voice to Simplify Task Updates in Smartsheet
Hi everyone, I wanted to discuss how AI-driven input methods, especially voice, could simplify everyday tasks and update workflows in Smartsheet. In many project environments, updates, action items, or follow-ups arise during meetings, calls, or brief discussions. These are often added to Smartsheet later, which can lead…
-
Smartsheet form with built-in AI
You could have a form with built-in AI. Eg: we have a form that becomes a row in our matrix tracker Smartsheet. For example: Marketing Manager Geraldo works with AI, so the form will start asking his name/email. Based on that, the form will make suggestions(what kind of Asset: Brochure, Flyer..) , category(AI for industry,…
-
Merged: elapsed days as a predecessor lag
This discussion has been merged.
-
Need to add total track the amount of times a person signed out equipment in 365 period from today
Here's the formula I'm using put it's coming back unparseable =COUNTIFS(Name:Name,"Yes", [Date signed out - OVERALL]:[Date signed out - OVERALL], AND(@cell >=TODAY(-365), @cell ,=TODAY(365) Appreciate any help.
-
Construction Project schedule
I have created a construction project schedule and am unable to determine why the critical path is not displaying from the start of the project. The file is attached for reference. If anyone is familiar with this issue, please advise. https://us.v-cdn.net/6031209/uploads/XHXHC4EHD5NN/project-schedule-12-19-2025.pdf
-
Automated Dashboard Snapshots & History
Problem: Current Limitations Ephemeral Data: Dashboards are "always live." As soon as the underlying data changes, the previous state of the dashboard is lost forever; there is no native way to view "what the dashboard looked like last Friday." Manual Workarounds: Users must manually use snipping tools or "Print to PDF"…
-
Use Sheet Summary as cell reference for a different sheet
I'm using salesforce connector to pull my team's hours information in real-time. The Salesforce connector sheet contains sheet summaries that I'd like to use a cell reference for a different sheet. I can't seem to find the best way or formula to do this. I don't want to use a dashboard with report widgets because I prefer…