-
IF/COLLECT? Report?
Hello, I'm at a loss as to how to solve my problem here. I have a sheet that contains multiple rows that are identical except for the person they are assigned to (Instructor) and if the Confirmed box is checked or not. See example. I'm thinking of these as groups of rows. For each group I only want to confirm one row from…
-
Can smartsheet create and display Binomial Trees?
Hi, I was wondering if anyone has tried to create and display a Binomial tree within Smartsheet? Is it possible, as I have been unable to find a template for it. I don't need it to run the calculations more for display purposes only. Thanks.
-
Count unique assignment IDs when the name matches
Hello, I'm struggling with a a cross-sheet formula where I count the number of unique assignments IDs when the name matches. I've tried the following without success: =COUNTIFS({Assignment ID}, {Name}, [Primary Column]@row) =COUNTIFS(DISTINCT({Assignment ID}, {Name}, [Primary Column]@row)) =COUNTIF(DISTINCT({Assignment…
-
My Date Helper Row is Showing the Wrong Centure 1923 Instead of 2023
Hi All, I created a sheet where my users will select from a dropdown of available dates. This column is set to Drop-Down so they only can select the dates I offer. (Column Name = Selected Date) I have a helper column that is set to "Date" and has a formula to turn the text data into a Smartsheet date. (Column Name = Date…
-
VLookup with 2 different criteria
Hi everyone, I am trying to figure out if there is an OR function that would work, or another way to look for only 1 of 2 values for a Vlookup. I have a cute little formula that helps me know if people signed off on a project - (the completion page looks up on the form results for an email and a date, and reports back to…
-
% Complete and Symbols
Hello - does anyone know how to create a formula that when a certain symbol is selected, it will return a status? Screen shot below. -Empty; return status 'Not Started' -Quarter, Half, or Three Quarter; return status "In Progress" -Full, return status "complete" Thank you for your help!
-
IF AND CONTAINS with >=TODAY(-7)
Hi, I have a formula I need help with please, =IF(AND(CONTAINS([Client Name]@row, {Sheet A Range 1}), IF({Sheet A Range 2}, >=TODAY(-7))), "Match") ______________ Name = Text column Sheet A Range 1 = Text column Sheet A Range 2 = Date column ______________ Any idea how to correct this #INVALID DATA TYPE? Thank you!
-
I am trying to figure out how to sum a cell based on another cells criteria.
So below is my data and I need a cost total for each items condition - 1 - Critical Item, 2 - Urgent Item and 3 - Preventive item by unit number. EX: how much will it cost to repair all 1 -Critical Items for unit 1 Each row in my sheet contains 15+ items, conditions and cost Any help would be appreciated
-
I need help implementing the "OR" function for a SUMIF scenario
I want to sum what is in "Total Deal Value" when the status is either "Approved" or "Exception Approved". There is something wrong with my syntax.... can someone help? =SUMIF([Approval Status]:[Approval Status], OR(@cell ="Approved"), (@cell ="Exception Approved") [Total Deal Value]:[Total Deal Value])
-
Way to get average number of submissions per day?
Working on an intake form with hundreds of responses and I wanted to know if there was a formula to calculate the average amount of responses per day. Thanks!