-
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…
-
Need to return the first NON-BLANK value if [Client full name]@row matches {Client full name}
I have a MASTER sheet containing client data, and an UPDATE sheet to use for processing updates to client data (i.e. users submit data updates via a form and the latest entries go to the top of the sheet). To ensure my master sheet contains the most up-to-date client data, I am trying to use an INDEX/COLLECT function to…
-
Index collect formula
Can anyone help me with a formula? I am trying to sum a column from another sheet based on what is selected in a multi select dropdown. I worked with the Pro Desk at Smartsheet and they provided me with this formula, however its not working . Perhaps I have parenthesis or comma off someplace?? =IFERROR(SUM(INDEX({Team…