-
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…
-
Want to match values in multiple columns
I want to match the JIRA ID in the Jira ticket sheet to auto populate the Reported Issue ID1,Reported Issue ID2,Reported Issue ID3 (Issue ID in Issue Reporting sheet), there are multiple issue ID for same Jira ID Is there a way we can auto populate Reported Issue ID's from Issue Reporting Sheet to Jira Tickets sheet? Is…
