-
Using SumIfs with a date qualification
Hi Everyone. I would appreciate any feedback on what I'm doing wrong. In the formula below, when I hardcode my dates below, I get the correct answer back. =SUMIFS({Tech Enablement-NCAL - Allocation}, {Tech Enablement-NCAL - Timeline Range 1}, HAS(@cell, $Resource@row), {Tech Enablement-NCAL - StartDate}, <=DATE(2026, 4,…
-
Smartsheet equivalent to a popup window or pivot table?
Is there anything like a pivot table in the smartsheet ecosystem? I am looking for a solution that is somewhat like a sheet reference, but perhaps saves the time of double entry? Case in point: those of you that use Concur travel or something similar, how do you organize the data and make it retrievable but also something…
-
Merged: Revert Sheet to [Time]
This discussion has been merged.
-
Using a reference sheet to bring in reference dates (e.g., 6 months ago, last month, etc)
I thought it would be easiest to create a reference sheet to house dates so I'm not constantly creating timeframe stipulators in my sheets, especially now that I am trying to create portfolio level rollups. When I observe the switch over from Mar to April, it seems like in order for the reference sheet to show April 1, I…
-
Flagging Tasks as 'Blocked' if Predecessors are past due
Hi everyone! New to Smartsheet and trying to build some features for my company. I've been doing a lot of reading and tutorials, and I think I'm close to the end of this problem. Like the title says, if a task goes past its due date, I would all of its dependents tasks to flip to 'Blocked' status. I made it so far as to…
-
Best Practice - How to introduce a new dashboard that will replace existing dashboards across multiple projects
History: Our PM's have redesigned a dashboard (status report) that replaces our current dashboard format used across all our projects. Problem: I need to figure out how to replace our current dashboard (and supporting Sheet) with minimal effort. We have a Template Library (Control Center users) so both the sheet &…
-
Tired of messy image attachments in Smartsheet?
Tired of messy image attachments in Smartsheet? I built a small tool that lets you upload images directly into **cells (not as row attachments)** — making sheets much more structured and easier to review. 🔹 Before: Multiple attachments per row → hard to track 🔹 After: Images mapped to specific columns (clean & organized)…
-
Use dependencies to set start and end dates independently
how can i use dependencies to help set both a tasks start AND end date independently (not using duration)? As an example, i would like row 3 start date to be row 2 start + 5 (I can get that by setting predecessor = 2SS+5), but I want row 3 end date to autopopulate with row 4 start date.
-
Predecessors Drop down list like MS Project
It would be a tremendous help in creating and maintain project schedules having the dropdown like in Project for selecting Predecessors it is very time consuming to have to jump out or have a second screen open to fined what needs added. This would be a huge help in schedule creation and monitoring.
-
Auto-populate parent/child rows in a separate sheet?
Hello! I was wondering if there was a way to have certain column data automatically transferred to another sheet. Once that data is transferred, I would like for that transferred data to automatically populate into an existing parent row (if the account name matches). Example: Sheet 1 is a request sheet that is auto filled…