-
hyperlinking to a folder and or file on our local network drive
I would like to hyperlink a folder to our company shared drive from smartsheet. I keep getting the error message "Invalid URL" I have seen from other comments that this is an issue, is this some feature that may be added by smartsheet? It would greatly benefit the way we could use smartsheets. Thanks for your anticipated…
-
Data Validation Dropdown Lists - Simple Feature
I would like to make a list of all my organizations open projects on one sheet, then use that list for a "Dropdown List - column" on multiple other sheets so that the user can select the correct project from this list rather than enter it in free-hand (without reference). The "dropdown list" must be updated automatically…
-
Box link in Smartsheet Form
Hello, We are consolidating document management into Box, and as part of that we want to avoid users attaching documents directly into Smartsheet. We can turn off uploading to Smartsheet on our Enterprise account, but before we do that I need to make sure that we have an alternate way for users of forms to include…
-
Archiving Project in Control Center Should Also Remove Project from Portfolio WorkApps
When you archive a project in control center, it does not remove the project from Portfolio WorkApps. This leads to confusion for project owners and others shared to the project when they still see their archived projects within WorkApps. The only way to remove a project from WorkApps is to delete the project from control…
-
Team Assignment Report Help
Hello All, longtime user of Smartsheets for work - first time poster seeking help. I am search for a solution in creating a report to show all of the assigned tasks from a Smartsheet that outlines all of the Classes our Org is holding for Staff this year as sorted by assigned Training Staff. Those Training Staff are…
-
Adding year to quarterly equation to count
I want to count how many projects in each network have expected completion dates within the quarter per year. For example, in Upstream, I know 3 projects will complete in Q1 2024 but 1 will complete in Q1 2025. The formula I'm using won't account for the year and count correctly for what I know are the actual expected…
-
Seeking advice on template sets.
I am new to Smartsheet and am hoping to get some advice on which template set would be best. My biggest concern is meeting the executive's requests. The executives are looking for a dashboard that shows an overview of the 20-25 projects that we will be running soon. Executives would like the dashboard to include project…
-
How can I write a formula to pull data based on dynamic columns?
Hi all, I'm trying to write a formula that will pull row information based on dynamic Columns. My goal is to understand the difference in hours worked between last week and the week before. I would like to be able to flag if a Person has not updated hours in a week. I have a 'raw data' sheet which has team member names in…
-
Calculate start date based off of end date
Hi All, Can someone help me with a formula? I've searched the community and haven't been able to find an answer. I already have a formula in place to calculate the end date based off of the start date and duration of project. However, if I have an already defined end date I'd like to calculate the start date based off of…
-
Task that lasts the duration of the project
I have a task I want to track that lasts the duration of each project. However, since the start/end dates can't be formulas, I'm wondering if there's another way to set this up in my template?
