-
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…
-
Auto publish Dashboard as Screenshot
I can publish dashboard as link but how to publish sceen shot at scheduled interval of time
-
CheckBox Formula
Greetings! So, I have a "Done" column and a "Status" column. Status column values = Not Started , In Progress, Complete Done value = Checkbox The Goal: When I check the "Done", I would like to have the Status column show Complete. I have partially achieved this with the following formula: =IF(Done@row = 1, "Complete")…