-
Issue with unable to save a project template in the same folder
Hello Community, I am having a challenge in saving a project template in the same folder, when I am trying it to save as new it gets saved in the sheets and not in the same folder, even when I am trying to set the location it doesn't show options and also doesn't give any list when trying to browse, can any one help me.
-
Why does the date default to 2025
I'm working on a Smartsheet for items that are in 2026 and I have some columns that are set to the date field formatted like 15-May-26. The issue is that when I enter the date like 15 May, normally I can hit enter and it would enter the year, but for some reason, it is still set on defaulting to 2025 as the year. Of course…
-
NEW PM Porfolio Template questions
In the Project List, I would like to link a project update cell located in each Project Plan to a cell in the Project List. The project list only gives me the option to link a column. How can i link data to come into the Project List? I can link data out.. When I attempt to link by column, the target column in the project…
-
basic formula im sure, but Im new to this
I am trying to write a formula that says the if the end date is before today that it selects the "Late" option out of the drop down in Status. I got most of the way there but keep getting an error. HELP
-
Need formula to dynamically populate multiple rows from cross-sheet reference
I need to create a sheet that dynamically displays all projects assigned to me from another sheet called "Project Request Intake & Validation." Requirements: The sheet must update in real-time (if a project is removed from the source sheet, it should disappear from my sheet automatically) Each assigned project should…
-
Timeline View: Center on Today with Options for Visible Date Range
Timeline view is great. It has become our new favorite. One drawback is that it currently opens with the blue line (indicating today's date) way off to the left. Most of our projects have been in play for some time, and we like to see full bars in the visual, from the Start Date to the End Date. To accomplish this, we are…
-
How to Cascade Task List Updates Across Multiple Workshop Instnaces
We run workshops multiple times per year (e.g., quarterly). Each instance uses the same task list and are all on the same worksheet. If someone updates the list for one quarter (e.g., adds a new item to print) they have to manually update the list for every other quarter. Is there a way to cascade updates so that changes…
-
Calculate percentage based on drop down response from one cell and value of another cell
I have a list of properties that I'm keeping track of. I have each building divided into suites (children) and each suite has a cell with its square footage. The total square footage rolls up to the building name. I also have a drop down column that shows if the suite is occupied or vacant. I need a to calculate the…
-
Free Collaborator User Bulk Upload - exclude Premium Application
The concern is that Free Collaborators should not have access to premium applications. However, during bulk uploads, premium apps are still being added. There is an option to 'Edit User Properties in Bulk', Furthermore, removing premium apps through 'Edit User Properties in Bulk' is only possible after users accept their…