-
Pulling Adjacent Cells
Hello, I have a column of task due dates, and an adjacent column that lists who the tasks are assigned to. In a separate column, I have a cell that shows the next upcoming due date using a formula. I would like to pull in a cell next to that the corresponding person that that next upcoming due date is assigned to. Which…
-
Duplicates from a a previous date
Hi All, I'm currently trying to create a formula to count a row as a duplicate if the same information was entered the day before. Example: [Duplicate 2] formula is currently the following (but I know is wrong): =IF(COUNTIFS(Orders:Orders, Orders@row, Date:Date, Date@row, Reasons:Reasons, Reasons@row) > 1, 1, 0) I want the…
-
Max formula returning column Name
I need a formula that will return the max value for a row based on the data in 5 different columns and then return the column name. Is this possible?
-
IF, Index, Match formula
Hi, I am trying to see if there is a formula that will look at the Cells in row 1, and if matched to the any of the weeks in column Week Of, will return the corresponding deliverable value in Column1. Attached is the clip of my smartsheet. Does anyone know if there is a formula that can do this? I have tried using IF,…
-
Using COUNTIFS with ranges of different size
COUNTIFS( range1, criterion1, [ range2, criterion2... ]) OK, I'm stuck. When using COUNTIFS, and both ranges only cover 1 column each, or both ranges cover multiple column, it works perfectly. But, when for example, range 1 covers only 1 column and range 2 covers more than 1 column, I get the following error message:…
-
Valid sheet cell value becomes #INCORRECT ARGUMENT SET when aggregated into a report
Hi, I have a formula which displays the correct value at the sheet level =IF([Date Answered]@row = "", "", (YEAR([Date Answered]@row))) example output = 2021 or if there isn't a date present the cell would be blank. However, when I aggregate the sheet rows into a report the cell values show as #INCORRECT ARGUMENT SET Can…
-
How to make a cell populate based on content of a referenced cell?
My goal: Choose a sales stage from a drop down list in a cell/column (sales stage) then have a different cell in a different column (probability) populate based on the sales stage. Example: Column called Sales Stage shows "Samples Sent" (from a dropdown list) --> Based on that "Samples Sent" selection, the cell in column…
-
Cross-Sheet Formula SUMIFS returning #UNPARSEABLE
Hello! I'm running into a weird error with a Summary Budget Top Sheet I'm trying to build. I have two sheets. One summary budget top sheet and one expense log sheet. The summary sheet lists all the expenses types available on the expense log and I am trying to create SUMIFS to group together specific types of expenses on…
-
Which formulae is it to compare 3 values and give me 1 of 3 different text options in a cell?
I have created a form that populates a sheet and the form asks multiple questions and then the sheet uses the answers to create 3 costs, so far very simple. However I want another cell to automatically display a result based on the 3 costs provided. I'm a contract manager and I will have 3 options I wish to display they…
-
Combine 2 formulas into one.
Dear Community, Can someone please help me on this how I can combine these two formulas together. Currently I am using them in two individual columns and both formulas are working fine. The column Status Override is checkbox column and if I select the checkbox column the overdue status will be removed. So basically first…