-
Trying to Flag Overlapped Participants in Meetings
So I am trying to find a way to flag if there are the same people in multiple meetings. I am working with a drop down type format for the list of participants, so I am not sure how or if there is a way to compare the individual entries of the drop down to other elements in the column to test for potential conflicts.
-
How to separate multi select values and collect distinct values?
Each period (P1,P2,P3 etc) we collect KPIs for our projects. In some new KPIs we have been asked to collect the answers involve multi select drop downs. What we would like to be able to do is to each period have a list of only the unique values. I have tried using a formula which uses JOIN, DISTINCT and COLLECT and it…
-
IF Function Resulting in Specific Symbol Given Specific Inputs from other Columns
Hi all, Wondering if I could get some help on writing out a function. I know that it will probably be some sort of advanced and lengthy IF function but am confused on how to write it out. I have a Smartsheet that is used to track data inputs from a form. This data is related to a specific order coming in. I would like to…
-
Is there a tool that would help me take snapshots of progress every 30 days?
I am trying to figure out how to make a progress report that would show the percent completion of our project 30 days before and 60 days before. Is there any tool that would help me take periodic snapshots or be able to pull all the data onto a sheet every 30 days?
-
Budget Management
All I wanted to show you how I am using smartsheet to keep my budget reporting in real-time. I have 3 sheets 1) A Budget sheet 2) An Invoice Sheet 3) A Project Action Log The purposes are as follows Budget sheet This houses my line my approved budget using MasterFormat and also my Non-construction costs like Architect…
-
Sheet Quick Edit
Hello, This may already exist but... In my smartsheet, I have linkages to other sheets where information gets entered (call this sheet 1) and then summarized on my sheet (sheet 2). It would be convenient to edit sheet 1 from sheet 2 in some sort of pop-up window so I never have to leave my main sheet. Something like this…
-
Populating Entire Columns Referencing Another Sheet
Hi all! Over the last week or so I have been trying to build a report that shows average tasks completed over a given 12 week period. So far I have been successful in creating the formulas for these, which have been working on dummy data. Now I would like to process live data from another sheet. Well ideally I would…
-
Online Active Performance Monitor on sheets
I recently ran into a situation where important automated row moves were getting stuck for sometimes hours at a time, instead of moving immediately based on their automations trigger. The structure was: Automated Move Row 2, from the Intermediate Sheet to the Final Landing Sheet, was the one getting stuck. I had…
-
Creating a Booking System with a Time Component
Hi everyone, I have the following asset booking system and received feedback that I should add a time component to it: Unfortunately, I haven't been able to get it to work correctly as, in the above screenshot, you can see that the booker is stating the asset is available when it is not. Additionally, the 'Assignee in…
-
Lock a row (preventing editing) while row is open
Hi there, we have a scheduling Smartsheet that we're having some troubles with. Users are booking appointments in the below view, but since the row isn't locked out while this is happening, we're ending up with double-booking because two users overlap using the row. We have multiple people in the sheet, so if two people…
