-
New to Smartsheet: Does it have the functionality we're looking for?
Our office is analyzing if Smartsheet will work on a new task we've been assigned. We would like to 1) send a Smartsheet to about 250 users, each user fills in a variety of data (some will have 3 rows of information and others will have about 200 rows of information), and then 2) later combine those responses into one…
-
Portfolio‑Level Gantt View Enhancement to Display Multiple Milestones per Project Row
I would like to confirm whether the system supports rendering multiple date fields (approximately 5–6 date columns) from a dataset within a single row in the Gantt or Timeline visualisation. The requirement is to display several milestone dates—such as multiple Gate Review events—on the same horizontal timeline for each…
-
As a admin, is there a way to report on all Smartsheets?
We have a user who can't find some smartsheets that they believe they have. As a Smartsheet admin, how can I report on all existing smartsheets, workspaces etc? (I do not have access to them, just need to report all their names)
-
Best Practice - How to introduce a new dashboard that will replace existing dashboards across multiple projects
History: Our PM's have redesigned a dashboard (status report) that replaces our current dashboard format used across all our projects. Problem: I need to figure out how to replace our current dashboard (and supporting Sheet) with minimal effort. We have a Template Library (Control Center users) so both the sheet &…
-
Merged: Gnatt will Have mUltiple Start and End Date
This discussion has been merged.
-
Viewing Last Updated in Sheet
Hello! Is there a way for me to track user interactions in sheets? I have found how to see last updated by. But am I able to get more specific with this? See when a sheet was last viewed? And when updated am I able to track what was changed at a cell level? Thanks!
-
How can I get this formula to work
Hi, I still have a lot to learn in Smartsheet, but I have been using co-pilot to assist. However, I need help with this formula that I cannot get to work. My goal is to strip the site names off any special characters expect for the first four letters# and "offnet. I'll appreciate the any assistance that can be provided to…
-
Merged: Sort Contact List Column Options Alphabetically
This discussion has been merged.
-
Count and Lookup - based
Experts, I need to count the values of each column excluding Today Value. Rest of the Yesterday and Blank values of respective columns like #New Hires, and drop the values in the 2 Yesterday Metrics. It is pretty easy to do a vlookup for Today, but if I need to cumulate the Yesterday and Previous day values. How do i do…
-
Count if Formula to retrieve multiple criteria
Hello Experts, I am looking for a formula to count all of the New Hires from Yesterday/Today column using Previous Days and Yesterday values.