-
Reviewing past personal messages?
When inviting sheet collaborators and giving them instructions via a personal message, if i do not Cc myself on the message, is there a way for me to see what was originally sent, or is the message gone?
-
Date-Time vs Date - Strange Behavior?
I noticed that if you neglect the fact that a date-time is not the same as a date, you get unexpected results. If you look at the image you see a date-time and a date column that is set to equal the column to its left. As you can see it does not produce an error, and it populates the date. However, only in certain…
-
I would like to copy rows to another sheet but....
I would like to copy rows to another sheet so that other departments can view /work out of the copied smartsheet. What happens if the master's columns are increased or deleted? Is Smartsheet able to match the rows into the correct columns?
-
Assigning One Person to Another Person
I have AR Specialists that are assigned to Property Managers. Each time I enter a new property and select the Property Manager from the drop down list, I want the AR Specialist column to automatically populate. If the Property Manager in column 1/row 1 = XX or XX or XX, then the AR Specialist = XX If the Property Manager…
-
COUNTIFS for assigned to CONTAINING a name
I'm trying to total the numbers of active assignments assigned to a person in a cell that can have muliple selections. .... it's not giving me an error but coming back as 0 =COUNTIFS( [Assigned To]:[Assigned To], CONTAINS("name", @cell), Status:Status, <>"completed") Anyone help!?
-
Add Duration to date/time
For a software release plan, I need to show the duration of a task but unable to translate my Excel formula to Smartsheet. Any thoughts? These are the fields I am using -
-
Lock a sheet to archive data
I have a sheet in which we capture each users time on our projects. I will call it the Parent sheet. Each year do a Save As New to start the sheet fresh for the new year. This Parent sheet links to several other sheets that continually change over time. I don't need to track the changes in the linked sheets but I do want…
-
VLOOKUP Formula
Hi Smartsheet community! This may seem like a simple question but I cannot figure out this formula for the life of me. I am trying to do a basic VLOOKUP formula. On sheet #1 I will have a column that lists employee alias's and a column that will VLOOOKUP that same alias's level from sheet #2. On sheet #2 it will be a list…
-
Linking reports to sheets
Hi Team, Is there a way to link multiple sheets (source data) to one report? I believe I can do this with dynamic sheets but we don’t have licenses to cover. Any ideas?
-
Automation - best practice question
I have a sheet with around 20 reports hanging off the back of it for a group of partners. When I assign them a task from the sheet I’ve setup automation to Emil them that there is new content on there report to look at. Is there a way to send a reminder or alert to an email address based on a cell change, therefor only…
