-
Count weeks in a Cycle
I know there is a function for counting weeks based on the start of the year. Is it possible to count weeks from a specific start date, instead of from January 1? For example, I might have 12 weeks in a cycle of a project, and would like to show (on a dashboard) that we are in "week # of 12 weeks" in a specific cycle.…
-
When a new row is created in smartsheet get the data from that new row and use it in Power Automate
I have a Smartsheet sheet which is populated using a Smartsheet form. When the form is submitted it creates a new row in the Smartsheet and inserts the relevant form data into the corresponding Smartsheet columns. I now want to use the data from that row in a flow in Power Automate. I am using the "When a new row is…
-
Impact of deleting/removing a user
What is the impact of deleting a user if they were previously an owner of sheet and groups? (Note; I have already transferred all of their items to someone else, but they were the original author of these sheets and had input (row entries and comments alike) . I don't want to lose knowing what they did in the past in case…
-
Open all Smartsheet hyperlinks in new browser tabs
Hi Community, Is there a command or shortcut that will open all Smartsheet hyperlinks in new browser tabs? I wish to test if there are any broken links. Thank you!
-
Dynamic View Tricks for Common Painpoints
I've been using Smartsheet's Dynamic View to streamline and automate workflows in my organization, which has led to stakeholder onboarding that has scaled to a large group of external users. There are common complaints that have surfaced from both new and existing users, which makes me curious about workarounds the…
-
'Most Common' Formula
Hello, I am trying to create metrics on tracking the versions of an applications we are developing, currently I am attempting to find which version is most successful after it has been run through a series of criteria. Example: Build 30 - Success Build 31- Success Build 31 - Failure Build 32 - Success The Application…
-
See Row Update Requests
Can you see a row update request someone else sent? I would like to be able to monitor requests from my team if possible, so they aren't duplicated. I've looked in the activity summary, but they don't live there. Thanks in advance, Regina
-
Conditional formatting in Gantt not working with dependencies
For some reason it seems like my conditional formatting rules aren't being applied to certain rows in the Gantt chart side of this sheet. The problem is resolved if I disable dependencies, but I need those and don't understand why this should matter since I don't have any rules related to status or % complete in the…
-
Function like UNIQUE in Excel?
Does Smartsheet have a function similar to the UNIQUE function available in Excel? The function allows you to select a range, and then provides a unique list from that list. In Excel Combining: SORT, UNIQUE & FILTER will provide a unique list excluding blanks that is alphabetized. I am constantly using that function within…
-
Automatically Update Numbers in Countdown Formula
Currently, I have to refresh every day I need to see the most up-to-date number of days remaining for an event. I'm surprised this doesn't exist already considering how many tools there are for event and project launch coordination.