-
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…
-
IF statement - How to return a result from two multiple sources
I was wondering if there is a way to do an IF statement to capture a result and add that result into another cell? eg. from A1 (if C2 =“NSW” return “abc computers’ in B2) note - I can’t put the formula in B2 as this a drop down list. the only other alternative would be conditional formatting but smart sheets only gives…
-
Creating a new Group
Good Morning, I use groups to give staff access to the different sheets that I build, it makes giving large numbers of staff access to a sheet very easy. But...today I tried to create a group the way I have in the past, "Group Management" | Create Group | ... I name it, then add staff and I'm good to go. Except for…