I'm trying to create a formula that gives me the value of the first row in the same column. [Find This Value]. There are a few obstacles: The formula is placed in the same column, BELOW value we're tr…
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is subm…
Hello I am looking for assistance with a formula. What I need is '# of days for COC Completion' to equal 'Date COC was Finalized' - 'Date COC Determined' with a cavoite that if 'Was PCT hospitalized w…
I have 2 sheets: Source Sheet: KI Tasks Report Target Sheet: MLE Access Management All three columns in each sheet are text Formula in MLE Access ProjCode column: =INDEX({CE+RxE From KI_ProjectCode}, …
Hi, I have a column where I want to basically extract certain words from it without having to create multi helper columns. If I do a nested IF(OR(contains) statement or an IF(and nested statements it …
I have a form for customer feedback with ratings 1-5 and an N/A option. I'd like to apply logic such that the N/A value is set to 0. So I can work with it in other columns with formulae, avg rating, e…
Hello! The sheet on the back end has multiple checkmarks to select what role the event is for. I am needing to create a formula that will give a Academy name based off of which checkmarks are checked.…
I have two different sheets and I need them to automatically populate cell data when data is entered. I have sheet A (my department sheet) that has many columns and rows (many of which won't apply to …
Hi Guys I have sheet - Incident Recoded, see pic below…. I have formula - =IFERROR(INDEX(COLLECT(CHILDREN([Incident Description]@row); CHILDREN(Modified@row); MAX(CHILDREN(Modified@row))); MATCH("MTC"…
I am tryings to create a risk formula for Program that has list of projects as a child. Following are conditions to mark the project as either Green, Yellow, Red or Blue: Blue: - Project has progress …