-
Complex JOIN(COLLECT())
Hello all, I'm hoping to use a formula to return a JOINED list of shared USERS for all sheets in Sheet 1. I have three additional sheets that contain all the supporting data, but since I don't want group names, is it possible to perform the user lookups from the groups sheet within the COLLECT function? Sheet 1: A list of…
-
<> in Formula
I am counting rows (projects) in my intake sheet that meet one dropdown option, but dont meet another. (I want Project Status= Site Control Initiated, but Site Control Status does not equal to SCA Signed). I created a filter on the intake sheet to quickly see these, and the count shows 223 rows. However, when I created a…
-
Trying to autofill an assigned person from a different sheet
I'm trying to get the assigned person with the contact list to autofill based on company position and project name. So I have Sheet 1, I would like the "Assigned To" to be auto-filled from Sheet 2, by using the Project name and Type on Sheet 1. Sheet 1 Sheet 2 - Sheet 2 is always filled out first to pick a group of people…
-
Can't figure out why formula is not working in my budget plan
Creating a budget plan using a Smartsheet template. I initially deleted the code names because they weren't useful to my project. The formula search_value was linked to code name and produced an error message. I adjusted the search_value and column_num to match the correct linked data and had no issues in any other month…
-
Create a Duplicate Flag
Hello, I am trying to create a flag that turns red when a duplicate name is entered. Here is the formula I have so far, but it keeps telling me it is "#Unparseable" =IF(COUNTIF([Client/Resident Name]:[Client/Resident Name]@cell) > 1, 1)
-
Function for Working Days Remaining
HI Smartsheet Help Team, I use the following function to calculate the working days remaining. =IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) However, I want to modify the function so that when it reaches the end date, it will become 0 because right now it becomes a negative…
-
I need a formula for counting days until Due date
I feel like this is a simple formula that I am over thinking. I have a sheet with one due date column. I want a formula to go in a second column that tells me how many days from "TODAY" is the due date.
-
More fun with functions =IF(OR
So, I am trying to set up a formula that assigns a person based on a teaching discipline. I have had some success, however, only when it comes to 1-to-1 relationships. I would like to assign an individual name based on any of several possible teaching disciplines within their purview. So, what I have that currently works…
-
Using IF/OR statement in a formula
Hi, I'm trying to have the status on Row 9 update to 'Complete' if either Row 10 or 11 have a status of 'Call - Scheduled' but I am getting an error. =IF(OR([Status10]="Call - Scheduled", [Status11]="Call - Scheduled"), "Complete") Thanks!
-
#IF INDEX/MATCH Returning #INVALID OPERATION
I am fairly new to formulas in Smartsheet, and I am having trouble with the following formula where I am trying to check a Checkbox from another sheet ("Devices Secured") and set a Text/Number value ("Device Security OK") to either "OK" or "Not OK" based on whether the Checkbox is checked or not. This seems fairly…