-
Formula Function - SMALL for dates with duplicates (ERROR)
Hi, I'm currently using a formula to INDEX my sheet and pick up the smallest date in a column, and then display the 4 smallest (or soonest) dates in that column to pull into my dashboard. The formula is as follows: =INDEX([Project Name]:[Status], MATCH(SMALL([Next Milestone Date]:[Next Milestone Date], 2), [Next Milestone…
-
Inventory
Is there a training video to show us how to do the inventory and features? We want to use this feature but I need some training.
-
Creating a new project from a template and updating row information using Zapier
Good afternoon. I am currently using Zapier to automate the creation of a project sheet once an initiative gets approved on a log. The current configuration is the following: * New initiatives are captured into a sheet called "Initiatives Log" through the use of a form * Approval of the initiative is captured on a column…
-
Editing Chart Widget
I am using a pre-built template dashboard and am trying to see the data that the chart widget is referencing which is displaying on the dashboard but am unable to determine what data is being used.
-
Workflow utilizing data uploader and a template
So here at my company, we have a project template. This template contains many setting, functions, workflows and conditional formats that help organize our information. We currently generate an excel template similar to the one in smartsheets then copy paste into our template. My question is regarding the best way to get…
-
How to Create A Template Set
I've created several project management files (sheets, reports, dashboards). How can I save these as a template set (package) for others in my organization to use/download? Or is it save as a workspace??
-
Sheet Permissions from Template
Can someone check my logic here? I have locked rows in my timeline templates that have formulas in them (VLOOKUP for a project summary at the top) that I need my PMs to not edit. Currently, they have admin permissions and can delete the formulas. It was suggested to me to make them editors in the workspace, but they'll…
-
Comments - Keep important ones on top
Hello, Are we able to lock comments on rows or sheets do that they stay to the top?
-
SmartSheet Jira Integration
Hi all, I'm new to smartsheet and have also purchased their Jira integration. I'm curious as to how many others here are using this integtation? There's a lot of quirks with the integrations so wanted to see what others thought of it and how they're using it. Cheers, Imran
-
Smartsheet in Commercial Real Estate
My team is working on incorporating smartsheet for our landlord and tenant rep clients, as well as our team. Any suggestions on best templates, etc to use?
