-
Attach checkbox column in the source sheet to a specific user per row.
Hi! I am trying to create DVs from this sheet that will do the following: In this screenshot example - Elizabeth is the roadmap owner, but Deb is the Calendar invite owner. So in Elizabeth's DV, I still need her to be able to see this row, but not be able to edit the Calendar Update Complete column. In Deb's DV, I need her…
-
Dynamic Dropdowns in Sheet Summary
Please add support for dynamic dropdowns in sheet summaries. Use Case: We have project stage & status dropdowns in the sheet summary of our project plans. When we want to add a new option, we need to go through every sheet and manually update the sheet summary dropdowns.
-
Hyperlink in Alert/ Automation
Hi, I would like to add a hyperlink to a Smartsheet report in an alert. The idea is that I want to direct the alert recipients to go to this report to complete a task. Is there anyway to get a hyperlink into the body text of the email alert? Otherwise I need to put the entire url into the body of the alert, and the…
-
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…
-
Cell values automatically reverting to previous values. Changes won't save.
I have a very serious concern. I am updating the contacts column to change the contact from Richard to Teresa. However, after about 10-15 minutes Smartsheet automatically reverts to the original contact. This has been happening for a week . I am very concerned because how can I be assured that changes are saved in all my…
-
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…
-
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 &…