I have been using this formula in various sheets to have a specific date pulled, depending on if a certain field is blank or not. It has been working fine, but all the sudden is now throwing a "blocke…
I have tried what I thought should be a simple formula two or three different ways. Here is the basis of the requirement. Multiple Months, Multiple Vendors with multiple invoices within a month, Multi…
Hi, I am working on a sheet where I have 6 fields that require the user to select a value. Each field's value will have a numerical (points) equivalent. I have created the 6 dropdown fields and was su…
Hello, I have 2 sheets and I want to pull information from sheet to another sheet if certain criteria are met. The first sheet, "Slot List", is a list of clinical trials and the columns contain the st…
I am trying to write a cross-sheet formula in sheet 1 (field name is Row ID) to display the Row ID from a second sheet if the second sheet Newest field and ED field are both checked (see below). I've …
Does anyone know how to write a formula that will sum up the last four rows only? Example- The GPO Volume dollar amount gets populated each quarter. I would like a formula that would remove row 11 and…
=IF(ISBLANK([Monday Job]@row, ""), INDEX(COLLECT({Per Diem Database Range 1}, {Per Diem Database Range 2}, [Employee ID]@row, {Per Diem Database Range 3}, [Monday Job]@row), 1),) Getting an unparseabl…
Hello, first time posting, long time smartsheet users. I am trying to include the parent row text in my formula but not sure how. My Formula will only pull the text of the CHILDREN but not the parent.…
Hi all! I have a report on a sheet that has many duplicate values, and for the sake of nice presentation I would like them hidden. To further explain my situation, I have a sheet I am referencing that…
I have seen various other questions in the community, but I can't quite get my equation there, I am trying to convert a drop down from a form to a date in the adjacent column. All dropdown items are f…