-
Timestamp Columns
Hi Smartsheet Community! 👋 I'm hoping to get some guidance on automatically capturing timestamps based on checkbox triggers. Here's my setup: I have a sheet with multiple checkbox columns, each representing a specific action: ✅ Receiving Call ✅ Insurance Approval ✅ Transfer What I'd like to achieve is having a dedicated…
-
How To Turn Checkmarks Into Bar Graph
I have 20 inspection locations and a rotate employees to inspect them monthly. Assignments are due every third Wednesday of the month. I manually check assignments that are turned in and manually create a bar graph to show the percentages of assignments turned in that month. Is there a formula to automate monthly…
-
What Smartsheet templates are you using for clinical trial tracking?
Hey guys. Currently, I’m in clinical operations. I got a bunch of Phase II & III clinical trials in Smartsheet. We moved from Excel a few months back and still don't know the best way to set things up! The main difficulties I encounter are as follows: Tracking site activation in multiple states it's too dark Enrolling…
-
👋 Hello from Kentucky! | IT & Manufacturing PM
The Professional Side: I’m a Project Manager in the Manufacturing sector, where precision and timing are the heartbeat of everything we do. My journey started in general project management, but I’ve found my true "geek gear" in the IT and Security space. I’ve made Smartsheet my "single source of truth" for keeping…
-
Portfolio Gate Reviews
I have 165 projects in the portfolio, each with 5 gates and ~120 steps in a project. As an example if a project has successfully passed gates 1&2 and is coming up on gate 3 review, I want to be able to see the rollup at the portfolio then "zoom in" to see the project plan details for a specific project and gate 3. With my…
-
Count % Completion of Checked Items by Each Sub Project
Good morning Smartsheet Community, I am trying to put together a grid that captures the percentages complete broken down by individual areas of a project. Below are the variables I am trying to capture Percentages To Capture Power Installation % Data Installation % Millwork Completion % Configuration % Installation %…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Need Help With Date Calculation Formula
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
-
Permanent Row ID's without using Auto-ID
Is there a trick to creating a column of unique values for each row that will not change after it is created? I cannot use Auto-ID because the row then gets copied to another sheet that utilizes Auto-ID and Smartsheet limits that. I'm stuck and ChatGPT keeps making recommendations that don't work.
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…